topic Re: How can I edit the fields that are exported from the query widget to a CSV file? in ArcGIS Web AppBuilder Questions

How can I edit the fields that are exported from the query widget to a CSV file?

KristinVernon — Mon, 13 Jan 2020 21:52:51 GMT

I configured a filter to allow the user to filter of a layer to be able to show data based on a range of dates. However, when this data is exported it shows more fields (such as the GlobalID, created_user, created_date, etc...) in the exported report, which I have set not to show in the pop-ups. Also, I have a field which, when the user enters the data, is a drop down of different options, however when entered in the database it is an ID number.

I assume that upon exporting the CSV there is some query that called in order to export the filtered results into a CSV file, would there be anyway to edit this query or format the fields that are exported?

I am using the Web AppBuilder in my company's portal.

Also, I noticed that I can configure the Attribute Table widget to show exactly what I want, however, I've read the export function is not currently operational 😕

Re: How can I edit the fields that are exported from the query widget to a CSV file?

RobertScheitlin__GISP — Tue, 14 Jan 2020 14:27:13 GMT

Kristin,

Portal 10.7.1 uses WAB 2.12 and there was a bug in 2.12.

https://community.esri.com/thread/235592-cant-export-query-result-to-csv-in-the-attributetable-widget

Re: How can I edit the fields that are exported from the query widget to a CSV file?

KristinVernon — Tue, 14 Jan 2020 14:46:54 GMT

Yes, I've read that. But I would mostly like to find out if there's a way where I can edit exactly what fields the Query widget itself exports? Possibly through the js files?

I would like to omit exporting fields such as the ID fields and so forth.

Re: How can I edit the fields that are exported from the query widget to a CSV file?

RobertScheitlin__GISP — Tue, 14 Jan 2020 14:53:12 GMT

https://community.esri.com/thread/195847-web-app-builder-how-to-limit-fields-in-export-to-csv-option-in-query-widget

Re: How can I edit the fields that are exported from the query widget to a CSV file?

KristinVernon — Tue, 14 Jan 2020 15:06:53 GMT

Yes, I also saw that question but as you can see below, when searching for that line in the SingleQueryResult.js file, I'm returned with "No Results".

The file that i am searching is in the ProjectName->widgets->Query folder. Possibly I am searching the wrong file? I also cannot find the file "ExportToCSV.js"

Re: How can I edit the fields that are exported from the query widget to a CSV file?

RobertScheitlin__GISP — Tue, 14 Jan 2020 15:21:17 GMT

Kristin,

The problem with working in Portal is the code is obfuscated and what you searching for could be a.fields or c.fields as the featureSet var is likely changed durring obfuscation.

Re: How can I edit the fields that are exported from the query widget to a CSV file?

KristinVernon — Tue, 14 Jan 2020 16:23:09 GMT

Ahh I see so:

featureSet.fields = lang.clone(layer.fields);‍

Is actually like:

d.fields = f.clone(a.fields); ‍

for me.

This works for one of my problem, the other problem is that I use Domains for two of my fields. Therefore while in my application it appears as follows:

When I export this to CSV it exports as:

I would like it to export the value and not the code.

Re: How can I edit the fields that are exported from the query widget to a CSV file?

RobertScheitlin__GISP — Wed, 15 Jan 2020 13:16:53 GMT

Kristin,

Sorry I am not sure about the domain issue fix.