RB User Guide > Tools > Query Maker > Query Gallery

Using published queries

RB9 only

You don’t have to start from scratch to generate reports. Save time by using queries made by RB9 staff and other users. You can customize the queries as needed.

1. Tools > Query Maker
2. In the Query Maker window, click Query Gallery.
3. In the Query Gallery window, all queries in the current library are listed. To find a query you want to use, use the Search By pane:

• Query No.

  Enter the query’s number, if for example, OMTI Support gave you the number of a recommended query.

• Table Name

  Enter the name of the table you want to perform queries on.

• Query Name

  Enter the query’s name, if for example, OMTI Support gave you the name of a recommended query.

4. Click . In the results returned, click > Download next to the number of the query you want to use in Query Maker.
5. In the Save Query popup, you can edit *Query Name, but you can’t leave it blank.
6. Check the Share with other users box if you want to share the query in-house.
7. Click Save, then click Close in the Query Gallery window.
8. To use the downloaded query, see Using previously-saved queries.

NOTE: Upload your own queries

You can also share queries you make in Query Maker with other RB9 users. See Publishing your queries.

Reference

• SQL

Step-by-step instructions

• Using previously-saved queries
• Publishing your queries