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; } } }

Is there a length limit when using setDefinitionExpression?

Andrew-Bowne

I have a javascript application that sets a definition expression to a map service layer based on user-defined criteria. There are instances where this expression can be very lengthy (for instance, one problematic expression is 24,000 characters).

Is there a limit to how long a definition expression can be?

Do (will) definition expressions use a proxy service?

Thanks,

Andrew

Find more posts tagged with

Accepted answers

RobertScheitlin__GISP

Andrew,

Wow a 24,000 character definition expression... Are you using a ton of AND or ORs in the SQL? If so you should try using IN instead. The limitation is not a hard set limitation and varies on the underlying Database used. A Google search will reveal several results and nothin with a specific limit, just general advice to reconsider your workflow if your query is that large, (like consider an inverse of the SQL statement).

All comments

RobertScheitlin__GISP

It is far more efficient than a ton of Ors.

Andrew-Bowne

Yes, it's a ton of "OR"'s. I considered doing an inverse query but I think that might be just as bad. (these are statewide sampling locations so there are A LOT of them. I will try using an "IN" statement and see if that works.

RobertScheitlin__GISP

Andrew,

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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