Datasource

This is a hidden field and appears in the Hidden Controls area. It does not display on the form.

See above for the Name field.

SQL
If you select SQL, specify the appropriate SQL query in the Parameter field.
REGISTERED
If you select Registered, specify the name of a registered datasource or view in the Parameter field.
Parameter
If you specified SQL for Source, this is the SQL to select from the database.

If you specified REGISTERED for Source, specify the name of a registered datasource or view.

Custom Add Where
This parameter specifies the content of the WHERE condition in a SQL query, without including the WHERE keyword.
Custom Add Where Params
This parameter serves as the parameters to substitute for the placeholder ? in the customAddWhere condition. You must include the data type of each parameter within the customAddWhereParams parameter.
Note: Datasource filtering is available based on the Date field, but not the Time field.

Below are two examples of queries using datasource filtering.

Note: Using the custom fields is optional. You can provide the entire query in the Parameter field.

Filtering on a text field

To create a DBLookup to show Workbrain users based on text field named wbuIdTextField:

Name
Provide a name for the field.
Source
Select SQL.
Parameter
SELECT * FROM WORKBRAIN_USER
Custom Add Where
WBU_ID = ?
Custom Add Where Params
INTEGER==#inputField.wbuIdTextField#

Filtering and displaying a list of shifts within a certain date range

To create a filter with two input parameters:

Name
Provide a name for the field.
Source
Select SQL.
Parameter
SELECT * FROM SHIFT
Custom Add Where
shft_start_time > ? AND shft_end_time < ?
Custom Add Where Params
DATE==#inputField.shft_start_time#~|~DATE==#inputField.shft_end_time#