When exporting a model, it would be really cool if there were an option to include sub-queried data. I know Salesforce is lacking in this area as workbench itself doesn't allow the export of child data (unless you copy and paste the html table bleh) so maybe I'm asking a lot?
Either way, maybe the data could come in a comma separated list, or bullets within a cell, or even an excel Database table!
Either way, maybe the data could come in a comma separated list, or bullets within a cell, or even an excel Database table!
Shmuel Kamensky, Champion
-
4,700 Points
Posted 3 years ago
Rob Hatch, Official Rep
-
45,128 Points
Just like you can use a template field to put child relationship records into a table display - you can use that same template code to put those records in your CSV export.
The export options are at the bottom of the table when you turn on the Export data property. There you can choose not to export all columns in the table and define your own. You can define a template (rather than a field) and put in code similar to what you see above and grab child relationship data. I added a semicolon to my template to faciliate the splitting you are talking about - though it all comes through jammed into one cell.
Not sure its ideal, but its a start.
The export options are at the bottom of the table when you turn on the Export data property. There you can choose not to export all columns in the table and define your own. You can define a template (rather than a field) and put in code similar to what you see above and grab child relationship data. I added a semicolon to my template to faciliate the splitting you are talking about - though it all comes through jammed into one cell.
Not sure its ideal, but its a start.
Shmuel Kamensky, Champion