Dynamically applying query def on a layer for the webmap

[VenkataSrikanth_Dasari]

Hi,

I need to apply a long query on the layer of a web map in javascript.. Need help on this..

If i apply filter with more than 300 conditions then layer is not working at all for query or anything else..

searchLayer._defnExpr='' //More than 4000 conditions..

Cheers,

Srikanth Dasari

[RobertScheitlin__GISP · Accepted solution]

Is it 300 conditions for one field? If so are you using the "IN" operator?

[VenkataSrikanth_Dasari]

Thank you for the immediate response.. what is the limit if we use IN operator??

[BlakeTerhune]

The limit for Oracle is 1000. I think SQL Server is in the tens of thousands (less than 60,000). I did see an interesting workaround by just splitting it up into two IN clauses:

Where Col IN (123,1234,222,....)
or Col IN (456,878,888,....)‍‍‍‍‍‍

If you have thousands of values, you might consider just making a table for comparison.

Where Col IN (Select val_col from values_table)‍

[VenkataSrikanth_Dasari]

Thanks for the suggestions. However, feature layer is too slow to render on the map.. and it is requesting multiple requests to the server with different extents which affects the performance..

Any other suggestions ?