Automatically Exporting SQL Query

[abdullah123456789]

Hello,

I have a question about the November 2024 version of Geo Scada Expert 2023.

I need to export data in CSV format at specific intervals. To do this, I first created a Historic View in the Server Config that calculates a 15-minute average. I'm sharing the image below.

Then, I added a variable called 'WLM_ID' in Edit Metadata. If the value in the relevant signal contains the word 'Instantaneous', I want it to print it every 15 minutes. Then, I added a "SQL Export" item and filled in the necessary fields. When I run the query I wrote in the historical list for any signal, I can output the values of signals containing the word 'Instantaneous' in the WLM_ID every 15 minutes. I can also manually run the 'SQL Export' item, which exports the data to the appropriate file path. The query I used are shown below.

SELECT

"His15MAvg"."Time" AS "CurrentTime", "CDBPoint"."WLM_ID", "His15MAvg"."Value" AS "CurrentValueAsReal", "CDBPoint"."CurrentQuality"

FROM

"CDBPoint" CROSS JOIN "His15MAvg"

WHERE

"CDBPoint"."WLM_ID" <> '' AND "CDBPoint"."Id" = "His15MAvg"."Id" AND ( "His15MAvg"."Time" BETWEEN { OPC 'M -15M' } AND { OPC 'M' } ) AND "CDBPoint"."WLM_ID" IS NOT NULL AND "His15MAvg"."Time" IS NOT NULL AND "His15MAvg"."Value" IS NOT NULL AND ( "CDBPoint"."WLM_ID" LIKE '%Anlik%' )

However, I need to do this automatically, not manually. I used the 'Schedule' element for this, but when I use it, the export process doesn't happen automatically. How can I configure this to happen automatically and every 15 minutes? Can you help me?

[geoffpatton · Accepted solution]

Did you Edit the Schedule, which is different than Edit Properties, and link the SQL Export and then set the action to Export()?

[abdullah123456789]

I didn't add the part you mentioned. When I link it with SQL Export as you said, it automatically started to pull the data. Thank you for help.