mirror of
https://github.com/zhouxiaoka/autoclip.git
synced 2026-10-02 02:34:34 +08:00
Kris K
f4957c5236
* feat: prepare v1.3.1 documentation and observability release * feat: add eight-language desktop interface and tray * fix: complete v1.3.1 locale and privacy integration * fix: provide shared version metadata to Docker frontend build
11 lines
513 B
SQL
11 lines
513 B
SQL
-- Rolling 7-day coverage audit, including legacy/development events intentionally.
|
|
SELECT event,
|
|
toString(properties.schema_version) AS schema_version,
|
|
toString(properties.analytics_environment) AS environment,
|
|
toString(properties.app_version) AS app_version,
|
|
count() AS event_count, uniq(distinct_id) AS devices
|
|
FROM events
|
|
WHERE timestamp >= now() - INTERVAL 7 DAY AND event NOT LIKE '$%'
|
|
GROUP BY event, schema_version, environment, app_version
|
|
ORDER BY event_count DESC LIMIT 100
|