Is there any way to get TYPEPKSTRING in flexi query result?

[former_member667499]

Hello Folks,

Is there any way to get TYPEPKSTRING in flexi query result?

I am getting result if i do run like this : select TYPEPKSTRING from {COMPENSATION}

While I am running this select {TYPEPKSTRING} from {COMPENSATION} i am getting below exception Exception message: cannot search unknown field 'TableField(name='TYPEPKSTRING',langPK='null',type=HMCOMPENSATION)' within type HMCOMPENSATION unless you disable checking

Any help/hint is appreciated. Thanks! =============== Thanks & Regards, Arpit

[andyfletcher · Accepted solution]

You're looking for the itemtype attribute that is inherited from the Item type.

e.g.

 select {itemtype} from {compensation}

or try something like this to see how it joins to composedtype

 select {ct.pk},{ct.code}
 from {product as p join composedtype as ct on {p.itemtype}={ct.pk}}

[former_member667499]

Yes - It work like a charm and i could accomplish what i was looking for.

Thanks!