Page tree
Skip to end of metadata
Go to start of metadata

Load Scripts are scripts that automatically run when the analysis is loaded. With them you are able to assure, for example, that your analysis always begins with a certain filter applied or with a selector option displayed.


Manage Load Scripts

  1. Load Scripts can be managed in the analysis settings in the tab: Load Scripts.

  2. Define the Load Script using PQL statements on the text box. If more than one script is applied, they should be separated by a semicolon.

  3. The add column section aids the input of Load Scripts. It allows the user to select a column from the connected databases and returns a default script based on it.
    The default script has a format: FILTER "TABLE_NAME"."COLUMN_NAME" <op> <value>

  4. The documentation shows the possible values the <op> (operator) might assume in the Load Script formula.

  5. Here you can find examples of useful Load Scripts formulas. Remember to replace the table names and columns according to the ones of the data tables connected to your current analysis.