Trouble with Code Gallery Workflow
It is this one here:
https://support.geocortex.com/parcel-selection-buffering-and-report-workflow
I have modified it some. I do not require to pull the report from the layer itself but rather export the buffer selection to an Excel file. I have removed any info related to the reports from it. It is very close to working but not where I want it.
In our case, we have the Parcel layer associated with an one-to-one datalink relationship to a SQL table. I am able to see the table results with those attributes displayed however I cannot get them out to Excel, only the data from the Parcel layer itself.
If I understand, I cannot simply export this associated data to Excel without using an external report to pull it however the built-in Export to CSV function is able to do this. I assume I must be missing something striaghtforward.
Any assistance would be appreciated.
Thank you. Cecil Coxen
-
Hi Cecil,
To return the datalink data rather than the layer data it would be best to use a SearchTableParameterQuery activity instead of a standard QueryTask activity. This should return the data from the table as a featureset. From there, you can simply add a FeatureSetToDataTable activity to convert it to a data, and a DataTableToXls activity to convert it to an excel file.
You would need to include a CreateTempFile activity to create the actual xls file, followed by a DisplayHyperlink activity to allow the user to download the file.
-Victoria
0
Please sign in to leave a comment.
Comments
1 comment