Option to include child objects in data export

  • 1
  • Idea
  • Updated 2 years ago
  • Implemented
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!
Photo of Shmuel Kamensky

Shmuel Kamensky, Champion

  • 4,328 Points 4k badge 2x thumb

Posted 2 years ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
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. 
Photo of Shmuel Kamensky

Shmuel Kamensky, Champion

  • 4,328 Points 4k badge 2x thumb
Ah I was exporting through the console. Skuid displays an elegant solution yet again. Thanks Rob!