Permalink
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
22 lines (19 sloc) 471 Bytes
[Module Metadata]
AUTHOR=Sarah Edwards/mac4n6.com/@iamevltwin
MODULE_NOTES=Keeping track of various values on a per-day basis.
[Database Metadata]
DATABASE=ADDataStore.sqlitedb
PLATFORMS=IOS
VERSIONS=8,9,10,11
[Query Metadata]
QUERY_NAME=aggregate_dictionary_scalars
ACTIVITY=Aggregate Dictionary - Scalar
KEY_TIMESTAMP=DAY
[SQL Query 8,9,10,11]
QUERY=
SELECT
KEY AS "KEY",
VALUE AS "VALUE",
DATE(DAYSSINCE1970*86400, 'unixepoch') AS DAY
FROM
SCALARS