Data Filter Formula Editor

Workmaster support filter formulas to select data returned from, Data Objects or Data Models.

The Filter Data Formula editor has a special display that shows you the result of running a filter. (Filters are also known as queries).

Such Formula Editors appear in the Data List widget or the Data Container widget or the Load Data actions. It is also used in Chart and Tables widgets to add a 'fixed filter' to the data shown.

How It Works

Suppose you have a data object of type 'Customer' and each customer has an email. To select only customers whose emails match a fixed email, you can use the following formula:

IF email is equal to "[email protected]"

The above filter formula will check the 'Customer' data object's 'email' field, and only return the first customer whose email matches the text within double quotes. (The 'Customer' data object is usually specified as a separate drop-down in the widget or action settings).

The Filter Builder

The filter builder interface lets you assemble filters using easy-to-use menus. The following examples use a 'Book' data object that has a title, author, publicationYear. It is connected via a 'Genre' list relationship to a 'Genre' data object - which has a description.

Remember you can use Page Parameters or formula functions (such as ITEMDATA()) to filter objects based on dynamic values.

1. Selecting a Book based on an ISBN value: Select 'IF' from the empty menu. Select 'isbn' from the field menu. Then enter a fixed text value in the value to compare against parameter:

1. Press the 'play' button to see results:

Using Complex Comparisons

The formula filter builder can be used to build complex filters. For example, you can find 'Books' based on a Genre contained within the genreList:

(Select genreList from book, then 'genre' from the next menu).

Or you can compare a field with a contained object's field: