Chat now with support
Chat with Support

erwin Evolve 2023.1.0 - General

Filtering Data

Page Queries and Filters

This page explains how to use page queries and filters so that your pages only display objects that match certain conditions that you specify.

By default Index Pages, and Association Type nodes on Object Pages, list all the instances of the Object Type you specified - for example all Processes in your model.

However, you can create association queries and conditional filters which result in only a restricted list. For example, you might want an Index Page which shows a list of Processes, but you only want to see Processes of a certain Category, or that are associated to another object.

These queries and conditional filters can be applied to most Index Pages, as well as most Object Pages which use Association Type nodes to display Associated Objects.

There are two types of conditional filters that can be applied to the results to form a query:

  1. Filters based on object properties

  2. Filters based on associations.

Filter Operators

Text-string filters and select-list filters can be combined in a formula using filter operators. This allows for greater versatility when filtering objects.

The filter operators and their functions are listed below:

Operator

Function

Description

=

equals

Matches to any values that are equal to the inputted value.

!=

does not equal

Matches to any values that are not equal to the inputted value.

>

is greater than

Matches to any values that are greater than the inputted value.

<

is less than

Matches to any values that are less than the inputted value.

>=

is greater than or equal to

Matches to any values that are equal to or greater than the inputted value.

<=

is less than or equal to

Matches to any values that are equal to or less than the inputted value.

IN

is within

Matches to any values that are one of the inputted list of values. Operates with List, Text and Numeric values.

Filter based on object properties

Filters based on object properties can be applied to any Layout or Behaviour on any Index Page or Association Type node on an Object Page.

These filters restrict the results based on one or more properties of the objects to be displayed.

You can add multiple property filters, which combine to form a single query where each condition must be met for the object to be included in the results, so for example:

Display all Processes where:
Category = 'X'
AND Validated = 'TRUE'

While individual conditions are joined with the AND operator in your complete filter query, when you add a condition referencing a Drop-downID or Single Line Text property, you can specify multiple values which are treated as OR within that particular condition. So, for example, you could create a filter query like:

Display all Processes where
Category = 'X' OR 'Y' OR 'Z'
AND Validated = 'TRUE'

Icon

Description automatically generated

IMPORTANT: You can only use OR conditions with the following standard property types: NameCategoryUUIDID. User-defined property types are not supported:

In addition, you can only use one OR condition in a filter set.

NOTE: The OR operator is shown as 'IN' in the Evolve Designer interface.

Add a property-based filter

Filters based on association

Icon

Description automatically generated

IMPORTANT: You can only use a filter based on association when you are not already using an Association Type node for any other purpose in your Index or Object Page.

In addition to property based filters, you can restrict the list of objects displayed on a page by way of association. This could be by association to any object of a specified type, or to a specific object or objects of a specified type.

For example, you could create a filter like:

Display all Processes where Category = 'X'
AND Process Is Associated To any Location.

You could extend the filter to reference a specific associated object, such as:

Display all Processes where Category = 'Y'
AND Process Is Associated To Location 'Z'.

You can even extend these basic examples to add multiple nested association conditions to filter the results by way of indirect association. For example:

Display all Processes where Process Is Associated To any Location
AND where Location Is Associated To Organization 'UK'.

Finally, you can of course add property-based filters to any association filter, enabling you to create sophisticated page queries such as:

Display all Applications where Date for Review > 'date'
AND Application Is Associated To an Organization
where Organization Category = 'X' OR 'Y'
AND Organization Is Associated To the Location 'US'

Icon

Description automatically generated

When filtering results by association on an Object Page, remember that the parent node will always be an Association, so the list you are filtering is a list of associated objects.

On an Object Page it is not possible to present a list of objects indirectly associated to the object that is the subject of the page. It is only possible to list objects that are indirectly associated to objects that are associated to the subject.

Add a filter based on association

Filters Properties

The following properties can be used to configure a filter:

Name

Notes

Average Rating

 

Category

 

Created By

Format: DD/MM/YYYY HH:MM:SS E.g.: 22/12/2015 14:34:42

Creation Date

Format: DD/MM/YYYYHH:MM:SS E.g.: 22/12/2015 14:34:42

Date Validated

 

Display Name

 

Freeze Level

 

Id

 

Name

 

Owner

 

Template

 

Total Comment

 

Unique Identifier

 

Updated By

 

Updated Date

Format: DD/YY/MMMM HH:MM:SS E.g.: 22/12/2015 14:34:42

Validated

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating