on 09-22-2015 8:43 AM
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
You can find direct subtypes with something like this:
select * from {ComposedType} where {SuperType} = 8796097413202
This will only give you one level.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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'
User | Count |
---|---|
8 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.