Home
Quick Queries/PQQs
Quick Queries can be used to save a set of actions so that they may be rerun at a later time.
Legacy Quick Queries/PQQs
It is now possible to edit and run legacy Quick Queries and PQQs (created in the legacy web interface of Insights Platform version 9 and prior) in TRS and interact with the resulting data.
Edit a legacy Parameterized Quick Query in MLW
You can open and edit a legacy PQQ in Macro Language Workshop.

Quick Queries/PQQs
Quick Queries can be used to save a set of actions so that they may be rerun at a later time.
- Block setup panel
  The Block setup panel allows you to add parameters to your analysis in TRS.
- Add parameters to an operation
  Adding parameters to an operation in your analysis allows you to create a Parameterized Quick Query (PQQ). Parameterized Quick Queries allow users to specify inputs each time the query is run.
- Edit parameters in an operation
  Edit parameters previously added to an operation.
- Edit a parameter with a large value selection
  You can use the Query tab of the TRS timeline to edit a parameter with a large value selection.
- Remove all parameters from an operation
  Remove all parameters previously added to an operation.
- Open a Quick Query/PQQ in TRS
  You can open and edit a Quick Query/PQQ in the TRS timeline.
- Edit a Parameterized Quick Query in MLW
  You can open and edit a PQQ in Macro Language Workshop.
- Run a Quick Query
  Run a Quick Query or legacy Quick Query to view the results of a set of saved actions.
- Run a Parameterized Quick Query
  Run a Parameterized Quick Query to view the results of set of saved actions with user inputs.
- Legacy Quick Queries/PQQs
  It is now possible to edit and run legacy Quick Queries and PQQs (created in the legacy web interface of Insights Platform version 9 and prior) in TRS and interact with the resulting data.
  - Edit and convert a legacy Parameterized Quick Query
    Edit a legacy Parameterized Quick Query and convert it to a version 10+ Parameterized Quick Query.
  - Edit a legacy Parameterized Quick Query in MLW
    You can open and edit a legacy PQQ in Macro Language Workshop.
  - Run a legacy Parameterized Quick Query
    Run a legacy Query Query/Parameterized Quick Query to view the results of a set of saved actions with user inputs.

Edit a legacy Parameterized Quick Query in MLW

You can open and edit a legacy PQQ in Macro Language Workshop.

There are cases where you will want to edit a legacy Quick Query or PQQ in Macro Language Workshop. However, you can add a new parameterization to your PQQ only in TRS.

To edit a legacy PQQ in Macro Language Workshop:

Open the Object Manager and locate the legacy Parameterized Quick Query.
Right-click the legacy Quick Query or Parameterized Quick Query and choose Edit query in Macro Language Workshop from the menu.
The 1010data Insights Platform opens the legacy Parameterized Quick Query in the Macro Language Workshop.
Note: In MLW, the legacy PQQs retain the same [[ \ \ … ]] syntax as that used in Edit Actions XML in the legacy interface.
Perform edits to your query.

Note: You can edit your legacy Quick Query or PQQ in MLW, but you cannot parameterize a selection in MLW. For that, you must use the timeline in TRS. See Add parameters to an operation for more information.

In this simple example, we changed the date selection, the default store, and the selection prompt in the PQQ.
Click render to run the query.
The query results appear in the right panel of MLW.
Click File > Save Query to overwrite the existing PQQ or File > Save Query As to save as a new PQQ.

Note: If you edit a legacy Quick Query in MLW and either overwrite the existing query or save as a new query, the Quick Query will remain in the legacy format and have the icon. To convert your legacy PQQ to a version 10+ PQQ, you must open and save the PQQ in TRS. See Edit and convert a legacy Parameterized Quick Query for more information.
To test your changes, right-click your legacy PQQ in the Object Manager and choose Run query in TRS.