Long Where in Query

[hussambukhari]

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

[hussambukhari]

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

[AnthonyGiles]

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?

[hussambukhari]

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?

[hussambukhari]

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

[RobertScheitlin__GISP]

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

[hussambukhari]

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.

[hussambukhari]

Any Idea to solve this issue!!!

[RobertScheitlin__GISP]

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.