About
The Condition setup section allows you to define specific criteria for your custom data data source to ensure only the most relevant records are included. By setting these conditions, you can filter your data based on specific field values or complex SQL-based logic.
To access these settings, navigate to Site administration > Plugins > Local plugins > Dash Addons > Manage data sources and select Create custom data source or Edit.
Available settings
Custom condition query – Specify raw SQL query conditions for the data source using alias keywords like (mnt) for accurate referencing.
Enable conditions
When enabled, the system applies the configured query and field conditions to the data retrieval process. When disabled, the conditions are retained but ignored during execution.
Field – Choose a specific field from the main table or joined tables to serve as the basis for a condition.
Operator – Select the relationship between the field and the value, such as "=" (equal), "!=" (not equal), "LIKE", or "IN (...)".
Condition – Choose the logical operator, such as AND or OR, used to connect multiple conditions together.
Value – Define the specific criterion against which the field value is evaluated.
Trash bin icon – Remove a specific condition from the configuration.
Add 1 condition(s) – Add a new condition group to the settings to further refine your data filtering.