distal-attribute
distal-attribute
distal-attribute
distal-attribute

Feature-Request: named ResultTabs and predefined Export-Filenames

sethos posted 8 months ago in General

Hello,

first, i work lots of years with heidiSQL, thanks for your product. Every month and some frequently i use a set of querys for analyses and reporting.

To make it easy and faster, if there was an Option to give the different result Tabs significant names instant of 'result 1' and once more, predefined Export file-names. The killer Feature was using of pattern to make them smooth.

My simple sample and what this mean:

/* manual Monthly Data Report A */
/* [ResultTabName='MonthlyReportA']  */
/* [SetExportFile='MonthlyReportA'] */
select 
  a,b,c
from table a
where condition = reportA
; 

/* manual Monthly Data Report B */
/* [ResultTabName='MonthlyReportB_%Y.%M']  */
/* [SetExportFile='MonthlyReportB_%Y.%M'] */
select 
  a,b,c
from table b
where condition = reportB
/* [DoExportCSV]  */
;

will give the result Tabs the names
MonthlyReportA | MonthlyReportB_2017.02

When you Export the result, the exportfilname will be prefilled to 'MonthlyReportA' etc. The last idea was an auto-export-Feature, the internal command / [DoExportCSV] / will Export last query result to the given filname.

The sample is simple but i hope, you like my idea.

regards thomas

Please login to leave a reply, or register at first.