topic Re: Query with a blank where clause in ArcGIS API for Flex Questions

Query with a blank where clause

KeithWeber1 — Tue, 18 Feb 2014 19:15:18 GMT

Hi all,

I am new to using the ArcGIS API for Flex. I want to query a table and return all records, but when I attempt to execute a query without setting the where clause, I get an error. If I set something in the where clause, the query executes correctly. Does someone have some example code on how to execute a query with no search criteria?

Re: Query with a blank where clause

RobertScheitlin__GISP — Tue, 18 Feb 2014 19:24:40 GMT

Keith,

When trying to return everything than you just set the where clause to 1=1. Now each map service has a limit set by default to 1000 features.

Re: Query with a blank where clause

KeithWeber1 — Tue, 18 Feb 2014 19:49:35 GMT

Thanks! That did the trick. In this particular scenario, the table should never contain more than a couple records.

Re: Query with a blank where clause

RobertScheitlin__GISP — Tue, 18 Feb 2014 19:56:31 GMT

Keith,

Glad that worked for you. Now you can help the forums out by marking this thread as answered.

Don't forget to click the Mark as answer check on this post and to click the top arrow (promote).
Follow these steps as shown in the below graphic:

Re: Query with a blank where clause

RobertScheitlin__GISP — Wed, 19 Feb 2014 00:07:20 GMT

Keith,

Close... You missed step one (the most important) in the attached graphic.