Permalink
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
25 lines (22 sloc) 565 Bytes
[Module Metadata]
AUTHOR=Sarah Edwards/mac4n6.com/@iamevltwin
MODULE_NOTES=
[Database Metadata]
DATABASE=CurrentPowerlog.PLSQL
PLATFORMS=IOS
VERSIONS=9,10,11,12
[Query Metadata]
QUERY_NAME=powerlog_battery_level
ACTIVITY=Device State
KEY_TIMESTAMP=TIMESTAMP
[SQL Query]
QUERY=
SELECT
DATETIME(TIMESTAMP, 'unixepoch') AS TIMESTAMP,
LEVEL AS "LEVEL",
RAWLEVEL AS "RAW LEVEL",
ISCHARGING AS "IS CHARGING",
FULLYCHARGED AS "FULLY CHARGED",
ID AS "PLBATTERYAGENT_EVENTBACKWARD_BATTERY TABLE ID"
FROM
PLBATTERYAGENT_EVENTBACKWARD_BATTERY