An SQL Export’s Output File Name supports ‘Trip Sequences’ that allow you to specify:
- A date, based on the date that the result of the SQL Query is exported (see Specify a Trip Sequence for a Date)
- A time, based on the time that the result of the SQL Query is exported (see Specify a Trip Sequence for a Time)
- Information about the SQL Export database item or any item that it references (see Specify a Trip Sequence for an SQL Export Object).
For example, you might want to export the result of an SQL Query on a monthly basis, to a file name that includes the month and year that the exported result covers. Or you might want to export the result of an SQL Query to a location based on the SQL Export item’s location in the Geo SCADA Expert database.
You can enter any combination of trip sequences at any location within an SQL Export’s Output File Name.
You can include character spaces within each trip sequence—these will be included in the final string when Geo SCADA Expert replaces the trip sequence with the actual information.
You can also include additional string characters—and symbols such as commas—in a trip sequence. For example, %Dddd the dd of MMMM yyyy%. To include string characters that would otherwise appear as trip code, enclose the characters in single quotation marks, for example, ‘MM’ (to print the characters MM).
To include the export date or time, you specify the relevant date or time trip sequence along with the Trip Sequence Time, to define the time or date information that is to be included.
With each trip sequence, Geo SCADA Expert replaces the trip sequence with the required information when it exports the result of the SQL Query.
Further Information
Specify an SQL Export item’s Output File Name: see Specify the Name of the Output File.
Specify an SQL Export item’s Trip Sequence Time: see Specify the Trip Sequence Time.