Hi Geethaka,
By default the Inbox query only supports Standardized Queries as per the settings enabled on the organization by your Administrator. In our 2.7 release (end March) we have updated the documentation for the Inbox query. Here is a snippet of that updated documentation:
Prepare for editing existing survey data—Survey123 for ArcGIS | ArcGIS
-------------------------------------------------
Additional documentation:
These queries also support SQL logical operators, allowing the query to perform more complex searches based on specific criteria. This example will return only results from users whose user names contain the user name of the logged-in user, as well as any text before or after it.
Creator LIKE '%' + ${username} + '%'
The following operators are supported by Survey123.
Operator | Description |
---|
ALL | True if all of the subquery values meet the condition. |
AND | True if all the conditions separated by AND are true. |
ANY | True if any of the subquery values meet the condition. |
BETWEEN | True if the operand is within the range of comparisons. |
EXISTS | True if the subquery returns one or more records. |
IN | True if the operand is equal to one of a list of expressions. |
LIKE | True if the operand matches a pattern. |
NOT | Displays a record if the condition or conditions are not true. |
OR | True if any of the conditions separated by OR are true. |
SOME | True if any of the subquery values meet the condition. |
Caution:
To run queries using logical SQL operators, your organization's administrator must disable the Standardized Query security option for your organization to allow nonstandard SQL queries. For more information on the ramifications of disabling this option, see about standardized queries in the ArcGIS Server documentation. For more information on standard and nonstandard queries, see standardized SQL functions in ArcGIS Online