setLayerDefinition : How to get list of records and display in a table and print the same table on PDF ?
I have dataset with project Name/Project Numbers. All are polylines featureclass.
1) I have workflow and I user setLayerDefinition to filter someof the layers available. I want to get list of filtered data and show as table similar to Query definition. (I can't use query definition as geometry data is huge to handle by query). How to do this ?Can we get featureset by setLayerDefinition ?
2) I need to print this data to pdf on printing template. How to pass Project_name/Project Number to table in PDF template ?
0
-
Hi Anjitha,
As long as you have the layers added to the site, then you will be able to filter the data and add this to a table.
In your workflow, you will use the Query Task activity to filter each one of your layers and extract only the features you want from each layer. Then you can use the "Select Features" activity to add all the featuresets to the result pane. Lastly, to open this up in a table, just use the "ShowResultsTable" command in a "Run External Command" activity and reference the collection name (from the "Select Features" activity). This will display all your results in the table.
If you also want the results to be returned in a PDF/XLSX/CSV file of some sort. Then you can convert all the feature sets into data tables, all them all to a dataset, and then reference that dataset in a "Export to CSV" or "Export to XLSX" activity to create the file content. Then to convert the content into a format that you can access, you will use the "Create Temp File" and "Display Hyperlink" activity in order to download the file using a link.
I hope this gives you a better understanding of how to approach this. Please feel free to respond with any questions you might have.
Regards,
Carmen0
Du måste logga in om du vill lämna en kommentar.
Kommentarer
1 kommentar