Search on characteristic values
In following search on characteristic values is described only for items to make the documentation more readable. Please note, that the same feature is also provided in the standard Product 360 for products and variants as well.
Search UI
In the web client it is possible to search for respectively filter the main table for product, variants and items with certain characteristic values.
In order to activate the characteristics filter bar you have to click on the icon highlighted in the screenshot below.
If you already have a predefined query, you can simply paste it in the text field and click "Filter". If you want to build a new query, the characteristics query builder supports you in doing so.
In this dialog you can select an active characteristic, click "Add" and it will appear in the area below where you can change the operator and the value you want to search for. Characteristic search criteria are connected using AND unless they are part of the same characteristic hierarchy in which case they are connected using the descendant operator (see below). You can also search for product, variants and items with specific lookup values in their characteristic values by selecting a lookup from the drop down menu and clicking "Add".
If you want to be sure what the created search criteria looks like or if you want to create a more complex criteria, you can switch to the "Advanced" view which allows you to type in text directly. The syntax used is the "Search Query Language" of the Service API. New characteristic constructs can be used together with everything the Search Query Language already offered before.
It is also possible to use characteristic queries and the query builder in the "Queries" section in order to further filter a predefined query.
Characteristic support
Characteristic operand
If you want to find products, variants or items that have characteristic values with a certain value for a certain characteristic the characteristic operand can be used.
The usage is documented here:
Documentation of the characteristic operand in the entity search: " Search entities using characteristic criteria" (Installation and Customization.zip)
Documentation of the characteristic operand in the Service API: " REST Characteristic " (Serv ice API.zip)
Descendant operator
If you want to search for a certain value combination within a hierarchy you can use the descendant operator.
Example:
These are the characteristics
And these are the values of Item A and Item B
If you use the characteristic operand and search for "Ingredient = Sugar AND Country of origin = Brazil" then the result would contain both items.
But if you only want those items that contain sugar from Brazil, then you can use the descendant operator and the result will only contain the Item A.
The usage is documented here:
Documentation of the descendant operator in the entity search: " Search entities using characteristic criteria " (Installation and Customization.zip)
Documentation of the descendant operator in the Service API: "REST Characteristic" (Service API.zip)