You are here: Features > Knowledge Library Index > Filter tab - New View Definition dialog

Filter Tab - New View Definition Dialog

Use this tab to create filters to limit the records that display in the view.

Available Properties for Filtering

Lists all the properties, including custom properties, that can be used to filter the contents of a view. Double-click on any property in this list to copy it into the filter definition box.

Filter

Displays the filter as defined. Type the filter definition in the definition box. Double-clicking the property in the Available Properties for Filtering list copies it into the definition box where it can be added to the filter.

A filter follows this syntax:

DATABASE FIELD (Property) comparison operator VALUE

Example 1

Country="Canada"

Limits the view to only those records where the country property has the value of Canada. Note that the value in the property has to match the value stated in the filter exactly.

Example 2

Filters can be made more complex with the use of & (and) and | (or) operators.

versionno="1.0" & language<>"French"

Limits the view to those items that have the version number 1.0 and any value in the language property that is not French.

Filters can also be enhanced by using Text functions to define the filter further. For more information on this, see the topic Text Functions.

Note: The maximum length for a database filter is 200 characters.

Status

Indicates whether the filter entered is valid or not. When the filter is valid, the status box reads OK.

Filter Tab - New View Definition Dialog

Cookie Notice