I'm aware that I can add an action to export the values of an aggregate to an excel/csv etc. However what I'm actually looking to do is export the values that appear in the "preview".
The data required for analysis doesn't exist in our other environments, so I'm unable to make any changes to the application itself.
I was hoping that if I could not export the preview data that I could at least copy/paste the rows of data out but that also doesn't seem to be supported,
Is there a way to export this data that I'm overlooking, or do I need to look at other methods (eg. access to the databases directly?).
There’s no built‑in way in Service Studio (O11) to export or copy the Aggregate preview data itself.
The preview grid is only a design-time helper; it doesn’t expose an “Export” or “Copy all rows” feature, and it’s not backed by a downloadable file. So:
Given your constraints (“can’t change the app in that environment”), your options are essentially:
Request direct database access On OutSystems PaaS you can request read-only access to the underlying SQL Server databases from OutSystems Support. After that you can connect with SQL Server Management Studio or your ETL tool and export whatever you need (CSV, BCP, SSIS, etc.). Download the database
Use application-side export (only if you’re allowed to change the app) Mentioning for completeness: normally you’d add a Screen Action that:
RecordListToExcel
Given the limitations, if the data only exists in that environment and you’re not allowed to deploy any changes, the realistic path is:
There’s no hidden feature to export the Service Studio aggregate preview itself.
The AI overlooked an obvious third candidate : do you have SQL Sandbox installed in that environment ? That has a feature to export the query results.
Dorine
Thank you Dorine, SQL access was my first stop and probably the best thing in this circumstance, it's just taking time to arrange access on my side. I was hoping for an interim solution.