Filter

copy link

The filter object represents a selection condition for records returned or modified by the query. Each filter represents an and condition in the query's where clause. All queries, except insert/values queries, allow filter conditions. The icons representing them are the following:

Filter expression

Incorrect filter expression


Video course: Creating database views
Video course: Running database queries in code

Filter conditions are normally created and edited using the Visual Code Editor. A new filter condition can also be added through the context menu of the query object.

Properties

Name: contains the name of the filter expression, used only to identify the filter. Changing this property is generally not necessary. It is best to use the Visual Code Editor to create or edit filter conditions.

Description: contains a description of the filter expression, used only as a description of the filter. Changing this property is generally not necessary. It is best to use the Visual Code Editor to create or edit filter conditions.

Expression: this property can be used to edit the filter condition expression. Editing expressions is normally done using the Visual Code Editor, so this property is not used. See also:

Outer join: specifies that this part of the expression represents an outer join condition. Normally, the Visual Code Editor is used to set a part of the filter as an outer join, by typing * token and selecting outer join in the list of valid clauses.

Comment out: excludes the filter condition from compiling. Warning: this operation may also change the structure of the links between the selected tables in the query.

Add task: creates a new task object linked to the filter condition. It serves as a reminder for future changes or to manage group work.

Go to: allows you to jump in the object tree to the objects related to this filter condition.

Find derived objects: searches for all objects in the project derived from the filter condition, including at multiple levels.

Find where used (object): searches for all points in the project where this filter condition is directly referenced in any way.

Find where used (content): searches for all points in the project where this filter condition or one of the objects it contains is directly referenced in any way.

A filter condition can be dragged and dropped onto a/an...

Filter condition: moves the filter in the list. This operation has no application effect, and only serves to reorder the objects in the list.

creates a copy of the filter condition and positions it next to the target filter condition.

Role: adds a profile item to the target role. If the item is active for the role assigned to the user session, the filter will also be active. Otherwise, it will not. This can be used to change the results of queries based on the user profile associated with the session.

Changed on: 15/12/2022 / From version: 8.5.3800