Options Filter allows one to search base on a set of populated options. One can search through the options through several mechanisms (See Display Type in the properties).

If your column stores the foreign key to another form table, you can make use of this Options Filter and set the Options Binder (i.e. Default Form Options BInder) so that you can search by using the label column configured.

 

Figure 1: Screenshot showing Options filter in a Datalist

Figure 2: Screenshot showing Options filter in a Datalist Builder

Figure 3: Filter Properties with Options filter selected

NameDescription
NameColumn name (for reference only)
URL Request ParameterURL Request Parameter (for reference only)
LabelSearch filter label
Type
  • Date
  • Date Range
  • Options
  • Text Field

Figure 4: Filter Properties - Configure Options Filter

NameDescription
Display Type

Define on how the filter should be presented to the users.

  • Auto Complete
  • Multi Select Box
  • Select Box
  • Text Field

When any of Auto Complete, Multiple Select Box and Select Box type is selected, all possible select options will be loaded on page load. If you have thousands of select options or sourcing them from Options Binder, this may cause significant increase on page load time.

Size (Multi Select Box)Control the height of filter when Display Type is set to Multi Select Box.
Default ValueDefault filter value
OptionsOptions to be made available for filter search.

Figure 6: Filter Properties - Choose Options Binder

NameDescription
Options BinderOptions to be populated dynamically using Options Binder plugin.