Advanced search

Use the Advanced Search option to perform detailed searches on the indexed attributes and properties. When you click this option in the Selection panel of the Demand Planning Workbench screen, the Advanced Search panel is displayed.

You can use the Search option to select an attribute in the Attribute field for performing an advanced search. The panel displays the appropriate search criteria options based on the attribute type selected in the Attribute field. The attributes are displayed with the integration codes, for example, ''ABC Classification Manual (ABCCLSM)''. The attribute types are:

  • Numerical
  • Textual

For numerical attributes, you can use these search criteria:

  • Range: To define a range of values. For example, 1 to 5.
  • Options: To specify conditions using operators, such as =, <, >, ≤, and ≥.

For textual attributes, a text field is displayed wherein you can specify a keyword.

Note: By default, the search is based on the keyword you specify.

You can use the wildcard (*) to search for partial words. For example, searching for rin*, displays planning entity results containing "rin" the text. The search is based on Lucene search syntax. The search results are displayed in the Selection panel after you specify the search criteria and click Apply.

You can add more search filters by clicking the Search option. Each search criteria specified in the Selection and Advanced Search panels are combined using the AND condition. For example, the Status =Open (from the Selection panel) is combined with the Product Name = Tamarind and the Product Line Description = Caribbean (from the Advanced Search panel) using the AND condition.

The applied search filters are presented as tags in the Selection panel, displaying the ad hoc results. You can remove the applied search tags by selecting the x on the tag. A search filter in the Advanced Search panel can be removed using the Delete option. The deleted attribute filter is removed when you click the Apply option.

Note: The Advanced Search panel retains the previously applied search criteria, which is displayed when you reopen the panel.