Filter

The filter field is used to create an interface through which an application developer can define specific criteria to be met by records that will be displayed in a list.

How to Create - Method 1

  1. Click the to add a field in your form.
  2. Choose “New Field”
  3. Select the table you wish to add the field to. Most of the time, this will be the current table you are on, called the current context.
  4. Select a field name and click “Choose Type”.
  5. Choose “Filter” from the list of field types.
  6. You can continue adding fields or click the “Select” button to finish adding.

How to Create - Method 2

This field is able to be placed on a page itself, not as part of a table's records.

Adding the Field

  1. Click the “Fields” button in the left toolbar to expand the list of fields available.
  2. Click on “Filter”, holding the mouse button down and dragging the filter field onto the page, releasing over the grey shadow where the field will be placed.
  3. Select a variant to use and click “save”. You can always change this later.
  4. The filter field will appear on the page in the location specified.

Accessing the Features

When hovering the mouse over the field, an icon containing a blue pencil over a sheet of paper will appear in the top left corner of the field. Click this icon to access the field features as listed above.

Features

Field features can be edited by clicking on the orange field icon when the presentation layer is displayed.

Field Label

Grid Appearance

Tooltip

Block Association

Default Value

Validation

Audit History

View Only

Filter Options

Variants Available

This field has nine variants that can be chosen from.

NameFormatLabel Placement
Dropdown of Fields with a label on the topDropdown boxTop
Dropdown of Fields with a label to the leftDropdown boxLeft
Dropdown of Fields with out a labelDropdown boxNone
Grid of Fields, Labels and Data Inline with a label on the topGrid, Data labels next to dataTop
Grid of Fields, Labels and Data Inline with a label to the leftGrid, Data labels next to dataLeft
Grid of Fields, Labels and Data Inline with out a labelGrid, Data labels next to dataNone
Grid of Fields, Labels above Data with a label on the topGrid, Data labels above dataTop
Grid of Fields, Labels above Data with a label to the leftGrid, Data labels above dataLeft
Grid of Fields, Labels above Data with out a labelGrid, Data labels above dataNone

Filter Types

The filter field can be configured to use any one of the standard text-type filters.

field type - filter.txt · Last modified: 2016/09/14 14:19 (external edit)
Copyright WorkXpress, 2020