How to know if a type is custom or system type?

Hi,

I'm programming a function which will return a list with the names and descriptions of only custom types. What is the attribute that difference between custom and system types?

Not all system types start with dm...so i can't use the type name to filter.

Thanks in advance.

Find more posts tagged with

Comments

Ramachandran

hi ,

Try this query which will return only custom types, (in case 'dm_document' as super type of your custom type)

select name from dm_type where name not like 'dm_%' and name not like 'dmc_%' and name not like 'dmi_%' and name not like 'dmr_%' ;

select name from dm_type where name not like 'dm_%' and name not like 'dmc_%' and name not like 'dmi_%' and name not like 'dmr_%' and super_name='dm_document';

select name from dm_type where super_name='dm_document';

Axel_Gil

Thanks Srinivasan,

But we have custom types that inherit from other custom types, so last two DQL you suggested are invalid for our case.

The first one.. we have DRS and other products installed which have generated some types...

I was asking about some function or attribute which differences between system or custom type...may be no exists...

Thanks

DCTM_Guru

There is NO attribute that you can query to distinguish between system and custom type. You can try to query against owner attribute for dm_type. If you use a different acct (other than the install owner) to create custom type, then this owner attribute would have a different value than the value of the install owner, who would own system types.

If this doesnt work, you can use these "general" guidelines:

where name not like 'dm%' and name not like 'dam%' and name not like 'dco%' and name not like 'cts%' and name not like 'wcm%'

Axel_Gil

Thanks!

If not exist such attribute, nothing more to say.

I will try with your recomendations.

Bye!