Quick Queries

Quick Queries can be used to save a set of actions so that they may be rerun at a later time. Using Quick Queries, you can also parameterize specifics of the analysis so that the user is prompted for input each time it is run.

If you applied certain actions to a table (e.g., 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 did 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 an input. Similarly, you may wish to make the column choice an input (e.g., to use Column2 instead of Column1) or even the 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 an input. Similarly, for tabulations, the choice of grouping columns, result columns, and summarization methods may all be made inputs, as can the parameters of most other actions. You can also prompt the user to select the table to which the analysis is applied.

Note the difference between saving actions as a 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 may run a Quick Query by double-clicking its title or icon in the Folders and Tables browser. Quick Queries are identified by the icons:
  • - denotes a Quick Query that does not require any user input
  • - denotes a Quick Query that prompts for user input

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 folders, tables, or queries.

You can also download text files containing either your Quick Queries or lists of users who have access to them.