Home > WebEOC > Admin Guide > Boards > Board Filters

Board Filters

WebEOC allows you to build data filters so that you can filter for the exact information you want to show in the board. Filters can range from simple to quite complex.

Applied By Default

When you indicate a filter is applied by default, the board automatically shows only those records that meet the filter's criteria.

Note: Filters are exported and imported with the board.

Statements

You can use any combination of AND and OR statements in your filters. An:

  • AND statement filters for records that meet all stated criteria.

  • OR statement yields records that match at least one criterion or set of criteria.

You can add groups of criteria, and you can build a hierarchy by adding groups within groups.

Advanced_Board_Editor_Filter_Criteria_Field.png

Example 1

For a simple filter, you do not need to use the groups feature. Your filter can consist of a single criterion, or you can include several. In the latter case, you also need to specify the relationship between the criteria by choosing ANY or ALL.

You specify that you want to see records with a high priority by adding that criterion. The criteria section shows: priority = 'high'. You then add that you want to see records with the status of Closed. The section shows: status = 'closed'.

You choose ALL. The operand AND appears between the two criteria. As a result, this example filters the road closures board to show only those records that have a status of Closed and are listed as high priority.

Example 2

Using groups helps you quickly build more complex filters. In this example, you set the board to show all road closures that have the status of Closed and further filter the list to show only those that have a priority of high or medium.

To do so, build two groups and set the relationship within each group and for the filter as a whole.

In this example, the first group you include is an AND statement. It specifies that you want to see records that have a status of closed AND a high priority. The second group is also an AND statement. It filters for records that have a status of closed AND have been assigned a medium priority. Selecting ANY at the top of the hierarchy indicates an OR statement.

The filter yields records that meet the first group of criteria or the second group. With this filter is applied, your Road Closures board shows only records that have a status of Closed and that have a high or medium priority assigned.

Note: Advanced filtering using groups is only supported when boards are published over WebEOC Fusion and both the publisher and the subscribers are on WebEOC 7.7 or later.

Operands

Operand

Query Option

in

Value must be in the list.

like

Result includes matches containing the parameter entered in the value field. This is comparable to a "contains" query. You can use the wildcard (%) with a "like" query.

=

Result includes entries that match the parameter entered in the value field exactly.

<

Result includes matches that are less than the parameter entered in the value field (numerically or alphabetically).

>

Result includes matches that are greater than the parameter entered in the value field (numerically or alphabetically).

<>

Result excludes those entries matching the parameter entered in the value field.

You must to post a comment.
Last modified

Tags

Classifications

This page has no classifications.