I am a heavy user of Aquafold Data Studio currently using version 18 and
have been using it since version 17. I find this software to be very
powerful compared to tools I previously used such as Oracle Developer
Studio and SQuirrel.
There is one thing that I find myself having to do manually all the time
though and I wanted to ask you if you could include this as a feature in
the next release.
In my work I have often to provide extracts of raw data to my clients. For
this I heavily use the Excel export function. Often similar requests come
again and again and I have to refer back to what was previously sent so I
make sure I keep the copy of this extract for future reference. For this
purpose I also keep the query by selecting the option to include the SQL in
the excel. As I do not want the clients to see the SQL but just have the
raw data, I cut these first few rows from the first tab, create a second
tab labelling it "SQL" and paste them into that tab and then hide that tab.
It would be great if this work could be automated and included in the next
release. Even if it is without the hiding part (as I guess most users might
prefer to see the tab to be sure that it is there and maybe are not aware
that you can hide tabs in Excel).
For your reference I pasted in my serial number:
BF19A411CBE8EDAC7B5252528A67691364CDE6ECD35604CB
|
25 KB
We added a feature in ADS v18.5 to allow the option of saving the SQL in a separate tab. Please see the attached Export_Excel.png screenshot. In the Export Data panel, Options tab, when you chose Format = Excel Workbook or Excel 2007 Workbook, a new "Create separate tab for SQL Query" option is available. Check this option to save the SQL Query in a new tab.
Issue #15469 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS v18.5 |
No time estimate |
We added a feature in ADS v18.5 to allow the option of saving the SQL in a separate tab. Please see the attached Export_Excel.png screenshot. In the Export Data panel, Options tab, when you chose Format = Excel Workbook or Excel 2007 Workbook, a new "Create separate tab for SQL Query" option is available. Check this option to save the SQL Query in a new tab.