0

I'm discovering Database Events and I created a script to store data daily:

tell application "Database Events"
    tell database "Stats"
        set theRecord to make new record with properties {name:mySimpleDate}
        tell theRecord
            make new field with properties {name:"Accounts", value:theCount}
        end tell
    end tell
end tell

I know how to retrieve one information by date:

tell application "Database Events"
    tell database "Stats"
        set theRecord to first record whose name = "24 September 2018"
        tell theRecord
            value of field "Accounts"
        end tell
    end tell
end tell

However I wonder, can I grab multiple results at once? (e.g every Friday to Monday results)?

and also can I do some SQL query with it like:

SELECT * STATS WHERE MySimpleDate BETWEEN XX AND XX

You must log in to answer this question.

Browse other questions tagged .