15.14.1 Queried Search Overview
The Queried Search tab in most scroll screens allows users to build, run, save, and load queries. The query can be run against any field in that specific module including the comments of each record. To access the Queried Search tab simply use the mouse to click on the Queried Search tab.
15.14.2 Creating and Running a New Queried Search
The Queried Search tab screen is the same for every module. Only the Fields change according to the fields available in each module. The above example is from the Address Book Database.
The top window has each Field in the table. In that window, users can scroll up or down to view additional fields of that table. Each row is the queried value of that Field. Within each row, users can define:
· Not check box
· Operator: Equal To, More Than, Less Than, Contains, Is Empty, In List, In Range (a “|” separates values in a list or range)
· Value, the actual search value
· Match Case, matches upper, lower, or mixed case.
The bottom window contains the results of the query after it is run. When the query is ready to run, simply press the Run Query button.
By example, if users wanted to search for a customer name of JOE, users could set the query to search for a PNAME of JOE. If PNAME only contained JOE, the operator could be left as Equal To, however we may have last names or multiple names in the PNAME field. Thus, change the Operator to Contains. To run the query simply press Run Query button.
Every Address Book entry that contains a PNAME of JOE will then be listed in the scroll screen.
Every field can contain a query value to further build specific constrains for the query. The ability to enter multiple constrains allows users to further narrow the search down to the criteria specifically desired.
By example, if we were to want to see all Address Book entries for the PNAME of JOE that do not reside in the City of San Jose, we could scroll to the City Field, enter a check in the Not field, an Operator of Equal To, and a Value of San Jose.
Users can further define multiple constrains through the Query Type field. The Query Type allows users to define the query as Exclusive or Inclusive. A query with multiple constraints that is Exclusive must meet all of the criteria to be listed in the scroll window. A query with multiple constraints that is Inclusive must meet only one constraint to be listed in the scroll window.
By example, if we were to search for an Address Entry that either has a PNAME of JOE or resides in San Jose, the Query Type would need to be set to Inclusive.
15.14.3 Saving, Loading, and Deleting a Queried Search
Once the query has been built, it can be saved for future use by pressing the disk save button.
A name and description can be defined per query. Queries can also be saved and made available to all users or just the user that created the query.
To load a previously created Queried Search press the load from folder button.
Once a user presses the load from folder button, all that are available to that user will be viewable.
From this screen, queries can be loaded or deleted.