Error in flexible search (Category)

[former_member740946]

Hi All,

i get the following error

cannot search unknown field 'TableField(name='allSupercategories',langPK='null',type=category)'

when i run the following query

select {categoryAllSupercategories} from {category} where {code} = 'B2C_Color'

although <itemtype code="Category" > have <attribute qualifier="allSupercategories" type="CategoryCollection">

thank you in advance

[moshenaveh]

Welcome and thanks for visiting SAP Community to get answers to your questions. Since you're new, I recommend having a look at our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html, as it provides tips for preparing questions that draw responses from our members.
For example, you can:
- outline what steps you took to find answers (and why they weren't helpful)
- share screenshots of what you've seen/done
- make sure you've applied the appropriate tags
The more details you provide, the more likely it is that members will be able to help you. Should you wish, you can revise your question by selecting Actions, then Edit.
By adding a picture to your profile you encourage readers to respond: https://www.youtube.com/watch?v=46bt1juWUUM

[mansurarisoy]

The field "allSupercategories" is dynamic, thus not stored in database. You can look the Dynamic Attribute Handler named categoryAllSupercategories to understand what it does.

<attribute qualifier="allSupercategories" type="CategoryCollection">
	<modifiers read="true" write="false" search="false" optional="true"/>
	<persistence type="dynamic" attributeHandler="categoryAllSupercategories" />
</attribute>