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 😕
Solved! Go to Solution.
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.
Kristin,
Portal 10.7.1 uses WAB 2.12 and there was a bug in 2.12.
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.
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"
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.
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.
Kristin,
Sorry I am not sure about the domain issue fix.