These conditions are set from the Triggered Launch panel of the publication and alerts schedulers, in the Create Condition dialog.
You can configure your own custom triggers, or a model-refresh trigger that will render publications and run alerts and subscriptions when the underlying data model is reprocessed.
Configure a New Condition
- Check the box to include triggers for the schedule.
- You can determine the launch of the scheduled item to be either when the conditions are met or not met, by selecting Trigger if True or Trigger if False.
- Delineate the condition’s formula by clicking on “New Condition”.
- The Create Condition dialog will appear.
- Insert the trigger condition in the fields along the top of the dialog. The first query field (yellow highlight below) must contain a dynamic function, and the second query field (red highlight) can contain either a dynamic function or a static value (which can be either numeric or textual):
- With the first field selected, find the relevant grid in the Content tree (blue highlight below).
- Select the relevant cell or grid component to add it to the formula window (red arrow). Add PQL functions to the query from the Dynamic and Common PQL functions libraries (green highlight below). You can incorporate the ChatGPT AI-driven PQL function into your formula to return results from Open AI.
- Test your selection or formula (blue arrow) and then click Set Formula (green arrow). The formula will be injected into the first field.
- Select the required operator (orange highlight below). This can be numeric (equals, greater than, less than, etc) or textual (starts with, contains, does not contain, etc).
- Select either Compare to Static Value (#), Compare to Dynamic Function (fx), or Compare to Last Updated Value (purple highlight below), in order to add the second field.
- If you've selected compare to static value, enter the value in the second field, then test and click Set Formula.
- If you've selected compare to dynamic function, find and select the required grid from the Content folders, and build the required formula. Test and click the green apply button. Click here for a list of dynamic functions.
- If you've selected compare to last updated value, find and select the required grid from the Content folders, and select the required cell(s). Test and click Set Formula. This option compares the current value of the given cell(s) with their previous updated value (i.e. the value this schedule, compared with the value last schedule).
- When you've built the condition, click the lower Apply button (orange arrow). The condition will appear in the Triggered Launch window of the Schedule panel.
You can add multiple conditions by clicking the New Condition button again.
If you've added multiple conditions, select the relevant checkbox and choose either AND or OR.
To create a group of conditions, select the relevant conditions and click the Group button. To remove the group, click the orange group bar (ensuring the conditions are not selected).
Use this option to trigger the conditional rendering of publications and running of alerts and subscriptions specified based on the reprocessing of the underlying data model(s).
- Click here to learn about model-refresh conditions.
The Pyramid Query Language or PQL (pronounced 'Prequel') is a language built into Pyramid's PYRANA engine to allow users to construct queries that can run against the many SQL data stacks that Pyramid can query natively. PQL includes a vast array of operations and functions that allows users to query data and build analytical logic.
The Create Query Condition dialog exposes Dynamic and Common functions. Dynamic functions are a set of specialized method that are designed to act on a given query 's result set. Common functions are a set of methods that are found in most programmatic and mathematical function libraries. These functions are used to perform logic on basic data without concern for data structures, context, or even source.
To add a PQL function from the library to the script editor, simply double click on it. You will then need to inject values into the function.
Pyramid's OpenAI integration enables you to use AI to generate scripts and images, dynamic text and infographics, calculations and lists, schedules, colors, and more. This allows you to generate a range of content, including complex code, by simply providing a text prompt.
You can incorporate the ChatGPT AI-driven PQL function (from the Common PQL functions) into your PQL formula to return results from Open AI. While this function cannot tell you about your data set, it can add additional information and background to your report.
Warning: AI-generated assets are generated from public domain algorithms, which can produce both erroneous and inconsistent/ random results. Use at your own risk.