topic Re: Dynamically applying query def on a layer for the webmap in Web AppBuilder Custom Widgets Questions

Dynamically applying query def on a layer for the webmap

VenkataSrikanthDasari — Fri, 22 Jun 2018 19:18:10 GMT

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

Re: Dynamically applying query def on a layer for the webmap

RobertScheitlin__GISP — Sun, 24 Jun 2018 23:39:45 GMT

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

Re: Dynamically applying query def on a layer for the webmap

VenkataSrikanthDasari — Tue, 26 Jun 2018 19:53:25 GMT

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

Re: Dynamically applying query def on a layer for the webmap

BlakeTerhune — Sun, 12 Dec 2021 10:56:06 GMT

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)‍

Re: Dynamically applying query def on a layer for the webmap

VenkataSrikanthDasari — Fri, 10 Aug 2018 20:22:40 GMT

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 ?