Improved UI Search Optimization

You can optimize your item/record search capability using the special character "%" in the search string. Search results can be refined for multi-value searches, case-sensitivity, and types of matches (exact and partial).

You can optimize your search string with following steps:

  1. Go to the UI screen where you’d like to search for records/items.
    • For case-sensitive "Starts With"
  2. Place the special character "%" at the end of a search string (like so, "TEXT%") to find case-sensitive "Starts With" records.
    • For case-sensitive "Ends With"
  3. Place the special character "%" at the beginning of a search string (like so, "%TEXT"), to find case-sensitive "Ends With" records.
    • For case-sensitive substring
  4. Place the special character "%" at the beginning and end of a search string (like so, "%TEXT%") to find case-sensitive substring records.
  5. Click "Search". The system will display the relevant results as per your query specification.
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.