RidgeStar
About
Locations
Manual
Reference
Notices
Email
HTML
Internet
Passwords
Processes
Results Lists
RidgeStar
Tools
Acrobat Reader
Comparators
Compute Age
Date Differences
Dates and Times
Editing Email
Fragment Fields
IP Mapping
Phone Numbers
Key Search
Show Characters
Similar
Text Format
Service
Logon
RidgeStar

Reference: Tools-Key Search

Logonfindtranslate
Get Started |Calendar |Locations

Key Search

Several Criteria specification spread throughout the Sites contain an ability to specify a distinct numeric value that can be used to look up a specific entry (typically a Database record). The value specified is a single numeric value made up of 1 to n digits. As an example, the Simple List will permit you to look up database entry 16 by simply specifying 16 as a Key value.

The character string that you can enter into a Key type criteria is in the general format:

[{=|<|>}] Value [{,|-}Value[,...]]

This syntax can be used to control which sorts of Keys should be used to develop or constrain the query that can be utilized. As examples:

Equal to a Key value (default)
Enter "16" to obtain entries with a Key equal to 16
Over a Key Value
Enter ">16" to obtain entries with Keys greater than 16
Under a Key Value
Enter "<16" to obtain entries with Keys less than 16
Multiple Key values
Enter "5,16" to obtain entries with Keys 5 and 16
A Range of Key values
Enter "5-8" to obtain entries with Keys between 5 and 8 inclusive
Multiple Keys mixed with Range of Key values
Enter "5,15,17-21" to obtain entries with a Key equal to 5 or 15 or in the inclusive range 17 through 21

This mechanism will be available for any Key type Criteria for 5.2 and up systems (typical popup string will say "Specific Value(s)"). It can be very flexible, but can also be a little complicated to get used to. But, once it becomes comfortable, it can also be very useful.