Conditions

Article • 29.12.2018 • 2 minute(s) to read

This article and its entire content are awaiting approval and will be released soon. You can get support for custom app development by asking questions in the forum; most questions get answered fairly quickly. Please do not use the contact form or private messages for technical support questions about building custom apps with the Novunex Platform.

Conditions are used to check if rules are met and to execute processes. A condition is an expression that evaluates to data records. For every existing data record the action (process) is executed and one process instance is generated for every data record being created. Variables of single data records can be used as input paramaters of the configured process action. There is a condition designer that can be used to generate simple rules, however more complex data queries can be achieved by using SQL queries.

Different Condition Options

  • Condition Designer - Use simple operators on attributes, e.g., Is in list, Is equal to, Is not equal to, Is in list, Is not in list, Starts with, Contains, Is null or Is not null
  • SQL Editor - Use SQL queries to generate a result set that can be used to start one or more processes (one process instance per data record in result set)

Attributes of the result set can be used as start parameters of processes. Simply use the syntax of context expressions to access columns of the SQL result set. E.g., #[Column1] or #[Column2].

Try to reduce the matching result set to a minimum. Too many data records could overwhelm the database or block the condition (forcing it to restart).

You can execute or test the condition by clicking on Test and by either selecting Test query to evaluate the result set. To run the condition select Execute rule, which takes only the first row of the query´s result response to execute the condition.


More information

  • Create a Condition using the Condition Builder
  • Create a Condition using the SQL Editor
  • Remove a Condition
  • In this article