Open Automation Software
Moving Data From Anywhere to Anywhere
1-303-679-0898

Frequently Asked Questions – Recipe

Recipe

Go to Configure-Options-System Logging. Enable the Recipe Transaction Log and the details of each recipe execution will be logged within the file.

Set the field names to use your desired aggregate functionsExample: AVG(myField), MIN(myField), MAX(myField), and SUM(myField).

In the Query String property enter the following:

WHERE DateAndTime <= CURRENT_TIMESTAMP AND DateAndTime > DATEADD(hh,-24,CURRENT_TIMESTAMP)