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 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.