Frequently asked question
Is it possible to use the LIKE parser in a JavaScript query?
Answer
The query.where clause allows any legal SQL WHERE clause operating on the fields in a layer. By using the '=' (equal sign) operator, the clause searches for exact results, in comparison to the LIKE operator that searches for a pattern or results containing part of the specified query request.The following code snippet demonstrates how the LIKE query is used in an SQL expression:
query.where = "ID LIKE ' '%123%'"The query searches for IDs containing the value, 123. The code snippet below demonstrates how the WHERE clause is used to produce a similar result, for specific data according to the desired classification:
var input = dom.byId("ID").value
var inputID = input.toUpperCase();
query.where = "ID = '123'"
Note: It is crucial to set the query object's WHERE clause correctly and use the '=' operator in the query statement to perform an exact match.
Article ID:000014290
Software:
- ArcGIS API for JavaScript 4 x
- ArcGIS API for JavaScript 3 x
Receive notifications and find solutions for new or common issues
Get summarized answers and video solutions from our new AI chatbot.
Related Information
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App