Contact us to schedule a demo or ask a question to learn how AdvantageCS can help you.

Advantage Blog

The Molly Minute >>

Using Search Filters

Smart Searches allow users to restrict the display of table entries to those of most interest to the user. Using the "Search For" field, you can enter a search string that would limit the display to only those entries that satisfy the string. 

Using the "Search For" field

There are different ways you can enter your search string, which will then result in different entries appearing:

  • Entry of a string returns matches on the exact string (e.g., ZA will return all matches on that string).
  • Entry of strings separated by spaces returns matches that satisfy all strings (e.g., Z(space) A will return all matches that contain both a Z and an A).
  • Use of double quotes will perform an exact (literal) search on the string (e.g., "Z(space)A" will return all matches that contain that exact string---a Z and an A separated by a space).

Using Multiple Criteria in a Smart Search 

Some Smart Searches allow you to filter on multiple types of criteria. For example, the Smart Search at MSTDAT/CTG allows you to search on Control Group Date, Control Group ID, Description, and Owner. However, what if you wanted to search by Control Group Date and Control Group ID? Instead of using the Green filter button, you can enter both "search for's" in the field.

In the screenshot above, in order to bring up the 3/23/09 ZUPL00 control group and not the 3/23/09 MMATH control group, you could type 3/23/09 ZUPL00 in the Search for field and it would limit the search where 3/23/09 is in any of the fields and ZUPL00 is in any of the fields. Keep in mind that what you enter in the field can be in any of the available columns.

Select Detail Searches

The Select Set Maintenance dialog at Advantage select views includes search capabilities to allow you to quickly access a particular level within the select; this may be of use if you are performing maintenance on a very large select, and you know the exact level you need to access.

You can enter the level number(s) you are searching for, separated by spaces (that is, you need not supply the periods between numbers).  A search on "10 20" and "10.20" would yield the same results.

The search returns all levels that include the criteria, regardless of their order within the select levels.  A search on "10 30" would return all levels that include those numbers---both those where 10 occurs first (e.g., 001.10.30) and those where 30 occurs first (e.g., 001.30.10).

Although Advantage assigns leading zeroes where necessary in level numbers, these need not be entered as part of the search criteria.  To find level 010, you need only enter "10".

Filed under: The Molly Minute