nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Finde mehr Beiträge mit dem Tag

Accepted answers

AntGiles

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

All comments

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.

hussambukhari

Any Idea to solve this issue!!!

hussambukhari

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...

AntGiles

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

hussambukhari

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

AntGiles

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

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.