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.

The wildcard (*) can also be used independently to perform partial-text searches by placing the wildcard before, after, or before and after the desired phrase. For example, searching for rin* display results containing words that start with ''rin''.

Lucene search syntax applies to all searches, and specific rules govern how reserved characters are handled. Reserved characters, such as | cause the search phrase to be split into individual terms, and the system matches based on whole words only. For example, using the search string B1|1|ROFNI channel, returns channels that contain the B1, 1, or ROFNI text, such as B1, B1@1, and B1@1@ROFNI channels.

Note: The @ symbol works differently in the Lucene search syntax. If you are searching for an attribute that contains @ symbol, you must enclose the phrase in double-quotes (“”). For example, “B1@1@ROFNI” returns the B1@1@ROFNI channel.

If you are searching for a partial string that contains the @ symbol, you must enclose the phrase in double-quotes (“”) and include the wildcard (*) before or after the search phrase. For example, searching for "B1@1@RO"*, returns the B1@1@ROFNI channel.

It is recommended to enclose any search phrase containing reserved characters in double-quotes (“”). 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.