topic Re: Limit Records for CSV Export in ArcGIS Web AppBuilder Questions

Limit Records for CSV Export

PatrickMcKinney1 — Wed, 10 Aug 2016 13:18:14 GMT

Is there a way to limit how many records can be exported to CSV from the Attribute Table widget?

If not, is there a way to limit how many records can be returned from a query on the service itself?

Thanks,

Patrick

Re: Limit Records for CSV Export

RobertScheitlin__GISP — Wed, 10 Aug 2016 14:04:04 GMT

Patrick,

It is likely possible. What is the criteria that you will use to limit the records?

Re: Limit Records for CSV Export

PatrickMcKinney1 — Wed, 10 Aug 2016 15:18:20 GMT

We'd like to limit the export to 1,000 records. It will be for a tax parcels dataset.

We're using the Enhanced Search widget, and would want the limit to apply to that tool as well, if possible.

Re: Limit Records for CSV Export

RobertScheitlin__GISP — Thu, 11 Aug 2016 13:21:10 GMT

Patrick,

Looking though the code this is going to be a lot harder then I thought. The AT widget does only export the rows you have selected to the csv.

Re: Limit Records for CSV Export

PatrickMcKinney1 — Fri, 12 Aug 2016 12:08:00 GMT

Yeah, that's what I figured. I don't think our Tax Assessment office will be keen on people being able to export the entire tax database.

Re: Limit Records for CSV Export

RobertScheitlin__GISP — Fri, 12 Aug 2016 12:51:53 GMT

Patrick,

You mentioned that you are using the eSearch. So if you are then the eSearch will only return the maxFeatureCount that the server allows and when you export to CSV from the eSearch Search results then the export will be limited to those numbers. If you remove/uncheck the taxlot layer from the AT Widget settings then it will not be present in the AT Widget and thus you can not export all the tax lots.