Wildcard Support in Report Center SQL Queries

Workflow Manager 6.0 | Report Center

Edition: This feature is available in Workflow Manager only.

In Report Center searches, data is always filtered using the SQL LIKE operator. You can combine the LIKE operator with wildcard characters to achieve the following results:

Wildcard Support in Report Center Queries

Situation

Rule

When no wildcards are used

If you do not enter a wildcard character in the Search box, then Report Center performs a “LIKE” search, meaning that it will identify any occurrence of your search text in the field being searched.

For example, if you enter the word test in the Search box, Report Center would interpret this as *test* and would return any records containing the word test (including MyTestFile and TestFile).

When wildcards are used

You can specify a * wildcard in the Search box to narrow the search results.

For example, if you want to return all records which contain the word test but do not begin with it, enter *test in the Search box. Then records with the word MyTest would be returned, but not records with the word TestFile.

See Also