Relative Object Parameter linking in SQL Exports

[EthanWortho]

Hello,

I'm trying to create some basic SQL exports so that I can export data on a schedule. 

The data i'm wanting to export are part of templates and I was wondering is it possible 

to use relative linking inside the SQL queries so that the export can be templated so when a new instance is 

created the export+schedule is already configured.

Something along the lines of  Select * from CDBHistory where "Id"  = "..Pump1.Running.ID" and RELATIVE TIME BETWEEN....etc .

Is it also Possible to use a relative pathname in the SQL Export filename so that the export file name 

will be unique for every instance created?

[BevanWeiss]

I haven't tried this, but it may be possible to use the newish Template Parameter stuff to do it (although I can't remember the exact limitations to this, it would at least let you simplify the configuration).

The other way I've done similar is with a really long interval OnInterval logic routine within the template.

When it's instantiated, it gets executed, which then configures the various settings you want.

It's not super nice though, so I'd look into the Template Parameter stuff first..

[sbeadle · Accepted solution]

In a template, edit property overrides.

Then choose Select and add the SQLQuery property of the SQl Export object in the template.

Find that in the list of properties and change the Override Type from 'In Instance' to 'By Expression'.

Then in the Expression field you can type your SQL query as a string (wrap with single quotes) and use the variable FullName in the filter. Use double single quotes to escape a single quote in a string.

e.g.

'SELECT TOP( 100000 ) "RecordId", "SeverityDesc" AS "~SeverityDesc", "RecordTime" AS "~RecordTime", "Source", "Message", "User", "Category", "Foreground", "SeqNo", "CommentNo" FROM CDBEVENTJOURNAL WHERE ( "~RecordTime" BETWEEN { OPC ''H-23H'' } AND { OPC ''H+1H'' } ) AND ( "Source" LIKE ''' + FullName + '.%'' OR "Source" = ''' + FullName + ''' ) AND ( "Deleted" = FALSE ) ORDER BY "~RecordTime" DESC, "SeqNo" DESC, "CommentNo" ASC'

The above query gets the events for the instance of the SQL Export.

[EthanWortho]

Thank you @sbeadle that has fixed the issue i was trying to solve