Select to view content in your preferred language

Search comma-separated values

390
1
12-20-2023 09:09 PM
SaurabhUpadhyaya
Frequent Contributor

Hi Team,

As per the requirement we are trying to implement search based on comma-separated values and display and highlight the results on map. Search will be on layer source or multiple layer source. Important part is performance, it should also be maintain.

We can apply this way but if we have records like 2000 countyname then it is not working .

var whereClause = "COUNTYNAME IN (" + countyArray + ")";

Kindly suggest some workaround to implement this functionality.

Tags (1)
0 Kudos
1 Reply
JoelBennett
MVP Regular Contributor

If you're using Oracle, it has a 1000 item limit for the IN operator.  There are various ways around this, and I recommend the answer suggested here.

0 Kudos