This tool is located on the RIMS section of the Reports tab.

Function

The RIMS Standard Query interface () is used to run preconfigured queries.

Layout

The interface has a Standard Query list, Query Criteria, and four controls.

Standard Query List

The Standard Query list appears at the top of the RIMS Standard Query interface under the title, "Choose Standard Query." This list shows all Standard Queries available for the current user. If a query contains a table that is unviewable by the current user due to permissions, it will not be displayed on the list. To run a standard query, the user must select a query in the list; a selection here will fill the Query Criteria section and enable the "Find Now" button which triggers the running of the query.

Query Criteria

The Query Criteria will be viewable once a query row is selected from the Standard Query list. This section will have an Edit Flag, Join, Parentheses, Information Type, Item, Logical, and Value column to help clarify the criteria that makes up the given query. These column types are described in the table below.

Button Controls

There are four controls offered on this interface:

Sort Order

If the user selects the Sort Order link, a pop-up will appear on their screen. This pop-up allows the user to view the current sort order, change the sort direction, and change the sort type for the Standard Query list. The image below shows the Sort Order pop-up.

Edit Sort Order

In the example above, the sort type is Query Name, and the sort direction is ascending order; this means the Standard Query list will be sorted by Query Name in ascending order. However, the user can edit these preferences in this pop-up. To edit the sort direction, the user can click the arrow in the "Sort Order" column. To edit the sort type, the user can choose one of these two actions:

1. Remove the current sort type and add a new sort type.
   • First, click the Sort Type located in the second table.
   • Then, click the "< Remove" button to transfer the sort type back to the first table.
   • Finally, select a new Sort Type(s) in the first table and click the "Add >" button to transfer it into the second table.
   • NOTE: The user can also click the "<< Remove All" button instead of selecting a Sort Type and the "< Remove" button; this selection will immediately clear the second table of all data.
2. Add more sort criteria to the second table.
   • To accomplish this, click on a Sort Type in the first table and click the "Add >" button to transfer it to the second table.
   • This will clarify the intended sort order by giving it further criteria.

Arrow Buttons

If the second table on the Sort Order pop-up has multiple criteria rows, the user can utilize the arrow buttons beside the second table to select their priority levels. Consider the example below.

In the picture above, the second table has two sort order criteria rows. The Query Name appears first in the list, then User appears second. This means that the Standard Query list will be sorted by ascending Query Name, then User. The first listed Sort Type will be of higher priority and will therefore sort the table first. Then, the second Sort Type will be implemented. The user can click on a Sort Type, then the arrow buttons to create a different priority order. The function of the arrow buttons is explained in the table. 

Apply & Close

In order to save any changes made to the Sort Order pop-up, the user must select the "Apply" button. This will implement the new Sort Order on the Standard Query list. If the user wishes to close the pop-up without saving the new changes and revert the Sort Order to its initial display, they can click the "Close" link at the top right of the screen.