Quick Queries/PQQs

Quick Queries can be used to save a set of actions so that they may be rerun at a later time.

A Quick Query is a set of saved actions that can be used by anyone on your team. To really harness the power of Quick Queries, add parameters to create a Parameterized Quick Query (PQQ). Each time the user runs the query, the user is prompted for specific input. Since the user can make selections and see different results, the PQQ becomes a flexible tool for data analysis.

If you applied certain actions to a table (such as row selections, sorting, linking, computed columns, summarizations), you may specify which parameters may be input each time the Quick Query is run. For example, if you performed a row selection such as Column1 is greater than 100, you may want to use something other than 100 the next time you run the query. Using Quick Queries, you can make that value a user input. Similarly, you may wish to have the user select a different column (e.g., to use Column2 instead of Column1) or even a different relationship (e.g., is less than instead of is greater than). Each of these parameters of the selection (value, column, and relationship) may be made into a user selection. Similarly, for tabulations, the choice of grouping columns, result columns, and summarization methods may all be made user selections, as can the parameters of most other actions. You can also prompt the user to select the table to which the analysis is applied. Parameters are added to operations in the TRS timeline.

Note the difference between saving actions as a Quick Query or Parameterized Quick Query and saving the results as a new table. When you save your actions as a Quick Query, only the actions are saved, not the results. When the Quick Query is run at a later time, the actions are applied to the table at that time. If the table had been updated or corrected, the results of the Quick Query would reflect those changes. On the other hand, when you save the results as a new table, the actual results are saved. If the original table were modified, the new table that you had previously saved would not reflect the changes.

You can run a Quick Query in TRS by right-clicking the query and selecting Run query in TRS. Depending on your workspace settings, you may also be able to run the Quick Query by double-clicking it in the Object Manager. See Define object associations for information on configuring your default settings for double-clicking an object.

You also have the option of viewing and interacting with a Quick Query in other ways. For more information, see Object actions by type. 

In addition, a Quick Query allows you to share your analysis with others, since you may give others permission to access it. When you share a Quick Query with another user or group, they must also have access to the parent folder of the Quick Query (and all of the folders in its full path) as well as any tables that the Quick Query references. View information about a particular Quick Query to find out its full path and the tables it references. For more information, see Share an object.