Skip to Content (Press Enter)
Back to Ideas
44
Like
Follow Idea
Export query result to excel
1331Views
25Comments
New
Aggregates & Queries

Hello,


Since it is very hard to get access to the database credentials for the Outsystems enterprise licenses, it would be very useful to have a button to export aggregate/advance query results to an excel file, and the service studio could download the file.


This feature is very handy for QA environments when sometimes developers don't have access to deploy code but they can see it.


Regards,

28 Oct 2019
Copy link to comment
Changed the category to
Aggregates & Queries
08 Nov 2019
Copy link to comment
Merged this idea with 'Button to export results of an SQL sentence' (created on 27 Feb 2021 15:28:20 by Clauber Tembra Tavares)
25 May 2021
Copy link to comment

Hello team!


Sometimes we need to save the result of an SQL query to do tests or even compare / merge with data from other sources.


With that in mind, I suggest creating an Export button on the SQL query creation screen, this button would be enabled only if there are no errors in executing the SQL sentence.



This comment was:
- originally posted on idea 'Button to export results of an SQL sentence' (created on 27 Feb 2021 by Clauber Tembra Tavares)
- merged to idea 'Export query result to excel' on 25 May 2021 04:52:38 by Daniël Kuhlmann
27 Feb 2021
Copy link to comment

I also suggested exporting the aggregate preview data: Export preview aggregate to Excel



This comment was:
- originally posted on idea 'Button to export results of an SQL sentence' (created on 27 Feb 2021 by Clauber Tembra Tavares)
- merged to idea 'Export query result to excel' on 25 May 2021 04:52:38 by Daniël Kuhlmann
04 Mar 2021
Copy link to comment

Great idea! Liked 



This comment was:
- originally posted on idea 'Button to export results of an SQL sentence' (created on 27 Feb 2021 by Clauber Tembra Tavares)
- merged to idea 'Export query result to excel' on 25 May 2021 04:52:38 by Daniël Kuhlmann
12 Mar 2021
Copy link to comment

Thanks André and David!



This comment was:
- originally posted on idea 'Button to export results of an SQL sentence' (created on 27 Feb 2021 by Clauber Tembra Tavares)
- merged to idea 'Export query result to excel' on 25 May 2021 04:52:38 by Daniël Kuhlmann
12 Mar 2021
Copy link to comment
Merged this idea with 'Save Test result from SQL queries as excel or word' (created on 24 May 2021 14:58:07 by kirit guntuk)

This comment was:
- originally posted on idea 'Button to export results of an SQL sentence' (created on 27 Feb 2021 by Clauber Tembra Tavares)
- merged to idea 'Export query result to excel' on 25 May 2021 04:52:38 by Daniël Kuhlmann
25 May 2021
Copy link to comment

Many times when a piece of code where involves SQL queries and large dataset where we can set 'n' number of output results and would be helpful we can save the result of SQL in form of any file like excel which can help to easy the function of testing a large data sets. 



This comment was:
- originally posted on idea 'Save Test result from SQL queries as excel or word' (created on 24 May 2021 by kirit guntuk)
- merged to idea 'Button to export results of an SQL sentence' on 25 May 2021 04:41:55 by Daniël Kuhlmann

This comment was:
- originally posted on idea 'Button to export results of an SQL sentence' (created on 27 Feb 2021 by Clauber Tembra Tavares)
- merged to idea 'Export query result to excel' on 25 May 2021 04:52:38 by Daniël Kuhlmann
24 May 2021
Copy link to comment
Merged this idea with 'Export Advanced Query Output to Excel' (created on 21 Sep 2020 21:08:33 by Inês Serralheiro)
03 Sep 2022
Copy link to comment

Advanced Queries could have an option to export the entire output, including headers, directly to an Excel file.

This could be made thanks to a button which allows to "Single Export" data, i.e., as it is made nowadays (copy simply the result) or "Copy With Headers":


The headers would be the same attributes of "Output Entries / Structures" of the Advanced Query:


This would be very helpful because nowadays we can only copy results and paste them without any header, which makes it difficult to understand which attribute are we talking about:


21 Sep 2020
Copy link to comment

Very good ideia and a great tool to quickly export query data for testing!

21 Sep 2020
Copy link to comment

Although it's a test output but could be good for comparison and testing.

13 Oct 2020
Copy link to comment

It's really a usefull idea, could help a lot in teste context.

Please people give some traction to this idea

19 Oct 2020
Copy link to comment
Changed the category to
Aggregates & Queries
10 Jun 2021
Copy link to comment
Merged this idea with 'Export preview aggregate to Excel' (created on 17 Nov 2020 15:58:35 by David Castro)
18 Oct 2022
Copy link to comment

It should be possible to export preview data as an excel directly on service studio.

17 Nov 2020
Copy link to comment

I think this idea can be implemented, on the Edit Entity data feature also allows to copy/past column data directly into Excel (if you have the right platform version for this feature).

12 Jul 2021
Copy link to comment
Changed the category to
Service Studio
12 Jul 2021
Copy link to comment
Merged this idea with 'Download entity data to an excel' (created on 12 Aug 2022 11:23:38 by Carlos Mendes)
17 Aug 2022
Copy link to comment

It should be possible when we're previewing data, with filters or not, to download all that results (not truncated) to an excel file. For instance, just an option next to "Refresh preview data".

12 Aug 2022
Copy link to comment
Merged this idea with 'Export Excel on Preview Data ' (created on 02 Sep 2022 11:13:36 by Saravanan S)
03 Sep 2022
Copy link to comment

Hi Team,

When performing Preview data and Test data options from Aggregate and SQL, If the Service studio provides the capability to export those data into Excel it will be much more helpful. To immediately point out specific data from large datasets downloading it via excel will be highly useful.

Regards,
Saravanan Santhanam.

02 Sep 2022
Copy link to comment
Merged this idea with 'Export aggregate/SQL data to Excel/CSV' (created on 17 Oct 2022 13:45:45 by José Gonçalves)
18 Oct 2022
Copy link to comment

Aggregates and SQL could have an option to export results of the query to Excel/CSV/etc

17 Oct 2022
Copy link to comment
Changed the category to
Aggregates & Queries
18 Oct 2022
Copy link to comment