topic Re: Long Where in Query in ArcGIS JavaScript Maps SDK Questions

Long Where in Query

hussambukhari — Mon, 01 Sep 2014 17:12:57 GMT

Dear All,

I need your help, I'm in situation that I need to use large where in query such as below, I need your help in doing that where i'm facing Syntax Error in IE 11 but in Chrome and Firefox its working fine.

I need your help in either using Where in query or other way to do the same result, I used Proxy as will but its not working.

the long Where as below:

query.where = "Trim(LICENSENUMBER) in ('MF1026','MF104','MF1051','MF1102','MF118','MF1190','MF120','MF1206','MF1267','MF1286','MF1288','MF1300',

'MF131','MF1311','MF1329','MF1425','MF1429','MF1481','MF151','MF1518','MF1575','MF1577','MF1587','MF1589',

'MF1605','MF1618','MF165','MF166','MF1680','MF1690','MF170','MF175','MF1767','MF1773','MF1781','MF1835','MF1854',

'MF186','MF1893','MF1898','MF1901','MF1922','MF1937','MF1941','MF1942','MF1954','MF1958','MF1961','MF1962','MF1964',

'MF1974','MF1976','MF1989','MF2','MF2003','MF2006','MF2007','MF2021','MF2044','MF2058','MF2059','MF2066','MF2079','MF2089',

'MF2095','MF2096','MF2099','MF21','MF2101','MF2102','MF2125','MF213','MF2132','MF2144','MF2218','MF2250','MF2270','MF2291',

'MF23','MF2304','MF2320','MF2326','MF2338','MF2351','MF2377','MF2378','MF2394','MF2411','MF2426','MF2452','MF2495','MF2503',

'MF2522','MF2527','MF254','MF2542','MF2553','MF2555','MF2599','MF2617','MF268','MF272','MF291','MF2934','MF2958','MF3065','MF3087',

'MF3100','MF3104','MF313','MF3167','MF3179','MF3223','MF3226','MF3273','MF3303','MF3331','MF3335','MF351','MF3516','MF3525','MF3534',

'MF3580','MF3586','MF3611','MF3636','MF368','MF3693','MF3696','MF3743','MF3886','MF391','MF394','MF41','MF429','MF439','MF440','MF456',

'MF464','MF466','MF467','MF469','MF472','MF473','MF571','MF613','MF624','MF663','MF687','MF74','MF765','MF772','MF87','MF949','MF999')";

The services is :

http://geoportal.abudhabi.ae/rest/services/HealthMapService/MapServer/1

Re: Long Where in Query

AnthonyGiles — Mon, 01 Sep 2014 17:31:50 GMT

Hussam,

What is the result you are trying to achieve? I have queried everything in your layer an there are only 39 features In your hospital layer. Is it possible to use a LIKE statement?

If you are using the same list of license numbers each time you could create a view in your database that is based on that query, then select everything from that view.

Regards

Anthony

Re: Long Where in Query

hussambukhari — Mon, 01 Sep 2014 17:40:57 GMT

Thank you Anthony to reply, I had a REST services with more than 2000 clinic and center and I want to filter some of them best on the user query for the license.

can you please let me know if there is a better way to do that rather than the way I used above.

thank you again for your reply

Re: Long Where in Query

AnthonyGiles — Mon, 01 Sep 2014 17:44:26 GMT

is the list of licence numbers always going to be the same? If so you could create a view in your database or a definition query in arcmap so that you have another layer that is already filtered

Re: Long Where in Query

hussambukhari — Mon, 01 Sep 2014 17:49:41 GMT

unfortunately there arc server is hosted with in different entity where just I can consume their REST services.

and the health facility might be change every time...

Re: Long Where in Query

AnthonyGiles — Mon, 01 Sep 2014 18:05:12 GMT

The trouble your probably running into is the character limit that occurs in a URL within IE:

http - What is the maximum length of a URL in different browsers? - Stack Overflow

i'm not sure if a 9.31 server accepts requests as POST instead of GET or as SOAP instead of REST but it would be worth looking into that option.

all the other option could be to cut down your query into multiple queries than combine them back on the client

Re: Long Where in Query

hussambukhari — Mon, 01 Sep 2014 18:09:33 GMT

Thank you Anthony, I will do what you suggest.

Re: Long Where in Query

hussambukhari — Mon, 01 Sep 2014 18:12:35 GMT

just last issue, why the services is working fine when I use the rest services directly and but the same query in the query layer where it will run with out error in the IE

http://geoportal.abudhabi.ae/rest/services/HealthMapService/MapServer/4/query

Re: Long Where in Query

hussambukhari — Mon, 01 Sep 2014 18:21:30 GMT

this simple request

Re: Long Where in Query

AnthonyGiles — Mon, 01 Sep 2014 18:28:36 GMT

Sorry Hussam I don't understand your last question, could you re-phrase

Re: Long Where in Query

hussambukhari — Mon, 01 Sep 2014 18:33:34 GMT

just i'm wondering why if I use the where in the below link query with the same length of where statement above it will working fine with out error

http://geoportal.abudhabi.ae/rest/services/HealthMapService/MapServer/4/query

Re: Long Where in Query

AnthonyGiles — Mon, 01 Sep 2014 18:37:36 GMT

I do not have IE to see what is happening as I am on an IPad but are you sure that the URL is not getting truncated but still creating a valid query?

Re: Long Where in Query

hussambukhari — Mon, 01 Sep 2014 18:43:56 GMT

yes i'm sure as I attaché image below I used 1=1 and 1=1 as query where I repeated 100 times, that is very strange?

Re: Long Where in Query

hussambukhari — Mon, 01 Sep 2014 18:52:46 GMT

the string length was 2860 in the where statement I.e. 1=1 hundred times

Re: Long Where in Query

RobertScheitlin__GISP — Mon, 01 Sep 2014 19:38:48 GMT

Hussam,

The whole purpose of a proxy is to get past this limitation. As you mentioned in your other post I was helping you on, you are using a proxy and it is IE that the proxy is not switching to a post for the query and this seems to be a .net proxy issue. I have tested on IE 11 using your original query from the other thread and was able to duplicate your issue with the proxy in IE not using POST but instead using GET and thus the error. I would call this a bug that needs to be filed with the dev team for the proxy code here: Esri/resource-proxy · GitHub

Re: Long Where in Query

hussambukhari — Tue, 02 Sep 2014 00:19:14 GMT

Thank you Robert, I submit the issue for the dev team, but unfortunately that may take long time to be solve it and I need to find solution before 5 of sep.

Re: Long Where in Query

hussambukhari — Wed, 03 Sep 2014 04:51:29 GMT

Any Idea to solve this issue!!!

Re: Long Where in Query

RobertScheitlin__GISP — Wed, 03 Sep 2014 12:02:35 GMT

Hussam,

As John pointed out in the proxy resource GitHub page it is not a proxy issue as your actual query string is less than the 2k characters that IE allows with a GET. So the issue lies with the 9.3.1 ArcGIS Server service that you are querying somehow? I have no suggestions for this.