Release Notes › Known Issues › Queries and Reports › Limitation on Queries with Multiple Search Terms

Limitation on Queries with Multiple Search Terms

Symptom:

A query on a single search column performs a case-insensitive search, as expected. However, a query on multiple search columns performs a case-sensitive search where asterisks (*), which should be interpreted as wildcards, are instead interpreted literally. This problem occurs when the internally generated SQL code contains the OR operator in the Where clause.

Solution:

Limit your queries to searches on one column at a time when using Prompts. If creating your own query with multiple expressions, connect multiple LIKE wildcard expressions with the logical operator, AND.