Flexi query with the below condition.

[Former Member]

I have create 2 item type A and B. B extends A.I f I do a flexi query of B then i will get A's attribute also. Please help me with the flexi query to get only B's atrributes alone.

[arvind-kumar_avinash]

When you use the following query:

 SELECT * FROM {B}

you can't avoid A's attributes to be displayed because this is why B has extended A. But if you want the result to be restricted to the attributes of only B and its parent, and not to display the attributes of its children, you need to put ! after B in the flexible search query e.g.

 SELECT * FROM {B!}

However, you can always restrict your query results to the attributes of B only by mentioning the attributes instead of using * in the query e.g.

 SELECT {attr1},{attr2} FROM {B}

where attr1 and attr2 are the attributes of B

[Former Member]

Thank you.I thought there will some other possibility to get only child table attributes.