Basic Conditions

Reports that use basic conditions let you define search filters by selecting fields and search criteria for those fields. When you click a field that you dragged from the Table Palette to the Search Filter block, a panel opens that contains the conditions that make up the search criteria for your report. An expression is created after you define the search criteria. Multiple expressions are linked with a solid line and contain either an AND or an OR operator. You can select an expression to edit it.

Note: For information about custom fields and custom field types, see Field Types. For information about operators, see Report Operators.

search filter

The type of field that you drag determines the options and values that are available to you. The following list describes common features of conditions.

The following table lists the field types and describes the options that are available to them.

Field Type Options
Selection, User

If you can select values for a field, you can search for specific values or select multiple values to add to your condition.

For example, if you select an Approvers field, the names that are available as selections for the field are available in the Available Values list to the right of the operators. You can select approvers from the list to add them to your query.

If you select a selection field, the values that are available as selections for the field are available in the Available Values column. Use the right arrow button to move them to the Selected Values column.

In some cases, a text box contains Type here to search for a value. You can type a few letters in this box to filter the list of values. When you do this, the only values that are displayed are those that contain the letters you typed.

Date/Time

Select an option, such as Start of Last Week on the Special Value tab.

Alternately, on the Exact Value tab, click a date and select a time, and then click Accept.

If you want to specify an absolute number, select the Now checkbox, select + or -, and type or select the number of days. For example, a Help Desk manager wants a report showing all incidents that were submitted in the last 30 days. You select the operator, select the Now check box, select , and then type 30 in the days combo box. The expression becomes Date ≤ 30 days ago..

Relational SBM Composer does not have access to runtime data. Therefore, the only options are Query at runtime and None.
Non-Selection

If a field does not let you select a specific value, type a value in the text box. For example, if you select a Text field, such as the Description field, type a keyword or keywords to search for. Date/Time, Numeric, and Summation fields also let you specify a value.

In some cases, the text box contains Enter a wildcard pattern. For information about using wildcards, see Wildcards.

Binary If you select a Binary field, such as the Active/Inactive field, select one value for your search criteria.
Trinary If you select a Trinary field, select one, two, or three values for your search criteria.
File If you select a File field, you can specify the is Empty value (find items in which a file has not been provided by a user) or the is Not empty value (find items in which a file has been provided).
URL If you select a URL field, you can specify the is Empty value (find items in which a URL has not been provided by a user) or the is Not empty value (find items in which a URL has been provided).

Related Topics

Field Types

Report Operators