Performing Queries on Collections

---

When you select a collection in the Properties list, the first 200 objects display in the Value list. Click the Run query on collection name (if collection name is the name of the collection you have selected) at the base of the Value list to display a query form if you can to enter and run your query.

Click the Inspection Tool icon on the toolbar and then click Run query on allGLJournals.

Put query results into this data bucket

This option determines which data bucket the query results are put into.

and query on class

Select the class to query from the dropdown list. If the class has subclasses, the user can also select a specific subclass here.

For example, if you select the GLJournal class then only objects in this class will pass to the query.

And/Or

These options determine whether the search is an AND search or an OR search, if more than one query line is entered.

Query lines

Each query can consist, up to six lines. To add query lines click the More button. To remove query lines, click the Less button.

The query lines section has three parts: property, query type, and value. A value is not visible if no property is selected.

You can select a property that is on a path — for example: myGLAccount.accountNo.

The options for the query type depend on which type of property you have selected:

Query and Close buttons

Click Query to run the query. A progress bar displays the query progress.

Click Close to close the query form.

---