A checkbox will be displayed in the cell. If the checkbox is selected or not depends on the SQL query.
If a query returns no result rows or a result with a value of 0 or an empty string, the checkbox will be cleared. Any other return value from the SQL query causes the box to be checked.
Please note: Before using SQL queries within a rule, read the chapter Instructions for working with SQL fields in JobRouter carefully.
Please note: If you want to refer to a column from a subtable view, the following notation is generally required: [<subtableViewName>_<columnName>]
SELECT DISTINCT mimetype FROM JRFILES WHERE mimetype LIKE '%[subtableViewFileDetails_mimetype]%'
Property |
Description |
|---|---|
Name |
Element name |
Label |
The label becomes the column header |
2nd label |
The label displayed behind the element |
Info Text |
Text to be displayed in the balloon |
Database link |
Selection of a JobRouter database link |
SQL |
SQL query to be executed against the database (See example). |
DB field |
Selection of database fields of type: VARCHAR, INT, and BIGINT |
Settings |
|
Disabled? |
The checkbox is disabled. |
Required? |
The box must be checked to send the step. |
Hidden? |
The element is integrated but hidden in the view. |
Scripting |
|
OnChecked |
Script to be executed when the box is checked. |
OnClick |
Script to be executed when the element is clicked |
OnUnchecked |
Script to be executed when the box is cleared |
Color |
|
Label color |
Color of the label |
