Scroll Window Queried Search

You are looking at an old Manual of pc/MRP,
the Complete MRP Inventory/Accounting Package.

Please click below for
the latest pc/MRP Manual

Please click below to
reach the pc/MRP Main Page

Manual Logo

Main Page Logo

 

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 ran 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 exactly the same for every module.  Only the queriable 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

·         Value, the actual search value

·         Match Case, match upper or lower case.

 

The bottom window contains the results of the query after it is ran.  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.  To do this press the  disk 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.