list objects of specified object type in dql

Hi i need to list objects of specified object type only not its sub types object.

Here is scenario.I have type "custom_type" (as sub type of dm_document).It has 2 objects.I have another type "custom_subtype"(subtype of custom_type) which has 3 objects.

when i use the query, select object_name from dm_document where type(custom_type) , i am getting 5 objects as result instead of 2 objects.

Does any one have idea on forcing content server to list objects of specified type.

Thanks,

karthick

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

aflowers001

You could try this

select object_name from dm_sysobject where r_object_type='custom_type'

All comments

aflowers001

You could try this

select object_name from dm_sysobject where r_object_type='custom_type'

GlaucoFimLouzada

Hi,

You can try these:

1) For the 'custom_type':

select object_name from dm_document where r_object_type = 'custom_type'
select object_name from dm_sysobject where r_object_type = 'custom_type'

2) For the 'custom_subtype':

select object_name from custom_type where r_object_type = 'custom_subtype'
select object_name from dm_document where r_object_type = 'custom_subtype'
select object_name from dm_sysobject where r_object_type = 'custom_subtype'

Regards,

Glauco.

karthick

Hi thanks,its working..