PSFS IQ - Query Builder: How to limit the number of records returned by a query

How to limit the number of records returned by a query

To improve performance, you may find it useful to limit the number of records returned by a query instead of retrieving the entire set. This article shows you how to limit the results to show the number of records resulting from your query.

  1. Build the query the way you typically do by choosing columns from the Column Picker and specifying conditions.

  2. In the Return results dropdown list, select the number of records you want your query to retrieve.

    • The dropdown list is located above the Query Results panel. You can select to display all results (the default) or select a value between 50 (the minimum) and 5000 (the maximum) records.

    • We recommend that when you first run a query that you select the lowest number of records. The more records you select, the more time it takes for the system to process the query. If the system detects that a query will return a large number of results, it displays a message to let you know that processing may take a while. You can then cancel or continue letting the query process. Canceling and then selecting a lower number of records from the list can help the query run faster.

  1. Click Execute Query.

    • The number of records you selected is displayed in the Query Results panel. For example, if you select Return 100 results, you see the first 100 records returned by the query.

    • Note that if you specify a sort on the results, the sort order affects which records are displayed. In other words, an ascending order sort returns the same number of records but a different set of N records from a descending order sort.


Related Articles

How to add, edit, or remove a condition

How to reorder the columns in your query results

How to rename a column heading in your query results

How to sort a column's data

How to remove duplicate records from your query results

How to create sub-queries in IQ



Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request