cancel
Showing results for 
Search instead for 
Did you mean: 

How to find out Sub types of an item type

Former Member
0 Kudos

Hi Experts,

How we can find out all the sub types of a pariticular item type using flexible search or SQL query.

We have TypePKString column in our table, but how to find the name of the type.

Thanx in advance

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

You can find direct subtypes with something like this:

 select * from {ComposedType} where {SuperType} = 8796097413202

This will only give you one level.

Former Member
0 Kudos

Thanx Matt for your help.

I started searching about it. and got the result.

to display all sub type of user item type

select * from composedtypes c1,composedtypes c2 where c1.SuperTypePK = c2.PK and c2.InternalCode = 'User'

Answers (0)