Depending on the display type, either a list with the result values of an SQL query or a textbox with an SQ query validation is displayed in the cell. The SQL query is always executed against a selected JobRouter database link. Once opened in one element, the database link is also available for other elements in the form without the necessity to establish a new database link.
Further information on the different display modes and the behavior of SQL_LIST elements in can be found in chapter SQL_LIST.
Please note: Before using these form elements, 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 |
Default value |
Preassigned value |
Database link |
Selection of a database link |
SQL |
SQL query to be executed against the database (see example). |
Order By |
Only for select box: Insert the columns you want to sort, separated by commas. |
Return column |
Only for select box: Insert the name of the column, where the value shall be displayed that is returned after selecting an entry. |
DB field |
Selection of database fields of type: VARCHAR, INT, BIGINT, and TEXT |
Result Columns (only for selection box) |
|
Label |
Column label which should be shown instead of column name |
DB field |
Database column name from the SQL result |
Settings |
|
Width |
Width of the list in pixels |
List type |
Choose your type of display: •Dropdown list •Auto-complete •Select box |
Empty selection? |
Only for dropdown lists: If this option was selected an empty selection will be inserted into the list. |
Disabled? |
The list is disabled |
Required? |
An entry is necessary here to forward the step. |
Hidden? |
The element is integrated but hidden in the view. |
Valid entry required? |
Only for auto-complete: Defines that only one value can be chosen from the list. |
Validation during loading |
Only for select box: Defines that an entered value is checked again while the form is loaded. |
Uppercase/Lowercase |
Only for select box: Data is compared case-sensitively. |
Direct Search |
Only for select box: The results are shown directly in the pop-up window without having to click on Activate filter. |
Maximum number of rows |
Only for auto-complete and select box: Maximum number of hits in the suggestion list or pop-up window. |
Scripting |
|
OnBlur |
Script to be executed when the cursor leaves the element |
OnChange |
Script to be executed when the value in the element changes |
OnClick |
Script to be executed when the element is clicked |
OnFocus |
Script to be executed when the element gets focus |
OnSelect |
Script to be executed when a value from the suggestion list is chosen |
Color |
|
Label color |
Color of the label |
Background color |
Background color of the element |
Text color |
Text color of the element |
