Wildcard Support in Reports SQL Queries
AdminStudio 2022 R2 SP1 | 24.01 | Reports
Edition:This feature is available in Workflow Manager only.
In Reports searches, data is always filtered using the SQL LIKE operator. You can combine the LIKE operator with wildcard characters to achieve the following results:
|
Situation |
Rule |
|
When no wildcards are used |
If you do not enter a wildcard character in the Search box, then Reports 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, Reports 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