Topics

03 Troubleshooting
Client, Server
Full-text search and searching a numeric field

A full-text search query that contains an OR operator in parentheses to search fields returns an error if the query also contains an AND operator to search a numeric field that is outside of the parentheses. For example, the following search query returns the error "Query is not understandable":

(Field Subject contains "First Doc" or Field Color contains "Purple") and Field Quantity = 2

You can enclose the numeric field in parentheses to prevent this error. For example:

(Field Subject contains "First Doc" or Field Color contains "Purple") and (Field Quantity = 2)