Improved UI Search Optimization

With the 24D release, Warehouse Management brings you a useful feature that lets you optimize the item/record search functionality for faster querying and highly specific results. Now, you can make use of the special character "%" in the search string to let the application narrow down your queries on a case-sensitive basis.

Depending on the different types of search optimizations you require, you can prefix/suffix the special character "%" in the search string, or, insert the special character "%" both in the beginning as well as the end of a search string.

The following table represents the types of query optimizations that can be achieved by placing the special character "%" in the search string:

Special case position	Example	Behavior
Case-sensitive "Starts With	TEXT%	Place at the end of a search string to find case-sensitive "Starts With" records. For example, "WIDGET000%" will return records with values such as "WIDGET0001" and "WIDGET0002". It will not find records with values such as "widget0001", "Widget0001" or "item0001".
Case-sensitive "Ends With"	%TEXT	Place at the beginning of a search string to find case-sensitive "Ends With" records. For example, "%EM0001" will return records with values such as "ITEM0001" and "MY_ITEM0001". It will not find records with values such as "item0001" or "Widget0001".
Case-sensitive substring	%TEXT%	Place at the beginning and end of a search string to find case-sensitive substring records. For example, "%ET000%" will return records with values such as "WIDGET0001" and "WIDGET0002". It will not find records with values such as "widget0001" or "item0001".

Special case position

Example

Behavior

Case-sensitive "Starts With

TEXT%

Place at the end of a search string to find case-sensitive "Starts With" records.

For example, "WIDGET000%" will return records with values such as "WIDGET0001" and "WIDGET0002". It will not find records with values such as "widget0001", "Widget0001" or "item0001".

Case-sensitive "Ends With"

%TEXT

Place at the beginning of a search string to find case-sensitive "Ends With" records.

For example, "%EM0001" will return records with values such as "ITEM0001" and "MY_ITEM0001". It will not find records with values such as "item0001" or "Widget0001".

Case-sensitive substring

%TEXT%

Place at the beginning and end of a search string to find case-sensitive substring records.

For example, "%ET000%" will return records with values such as "WIDGET0001" and "WIDGET0002". It will not find records with values such as "widget0001" or "item0001".

NOTE: You can also run multiple special characters in the search string using the conditional syntaxes "=", ",", "%<SOME_VALUE>%", "<SOME_VALUE>%" and "%<SOME_VALUE". For such scenarios, the system follows the order defined below to turn up search results:

"=" character for a case-sensitive, exact match search
"," character for a case-sensitive, multi-value search
"%<SOME_VALUE>%" pattern for a case sensitive, partial match search
"<SOME_VALUE>%" and "%<SOME_VALUE" patterns for case sensitive starts with and ends with searches

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

Oracle Warehouse Management Cloud Information Center