Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
1 contributor

Users who have contributed to this file

27 lines (24 sloc) 796 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,12,13
[Query Metadata]
QUERY_NAME=aggregate_dictionary_distributed_keys
ACTIVITY=Aggregate Dictionary - Distributed Key
KEY_TIMESTAMP=DAY
[SQL Query 8,9,10,11,12,13]
QUERY=
SELECT
DISTRIBUTIONKEYS.KEY AS "KEY",
DISTRIBUTIONVALUES.VALUE AS "VALUE",
DISTRIBUTIONVALUES.SECONDSINDAYOFFSET AS "SECONDS IN DAY OFFSET",
DATE(DISTRIBUTIONKEYS.DAYSSINCE1970*86400, 'unixepoch') AS "DAY",
DISTRIBUTIONVALUES.DISTRIBUTIONID AS "DISTRIBUTIONVALUES TABLE ID"
FROM
DISTRIBUTIONKEYS
LEFT JOIN
DISTRIBUTIONVALUES
ON DISTRIBUTIONKEYS.ROWID = DISTRIBUTIONVALUES.DISTRIBUTIONID
You can’t perform that action at this time.