mirror of
https://github.com/hanzo-apps/dataroom.git
synced 2026-10-30 14:47:36 +00:00
19 lines
388 B
Plaintext
19 lines
388 B
Plaintext
VERSION 4
|
|
|
|
NODE endpoint
|
|
SQL >
|
|
%
|
|
SELECT
|
|
pageNumber,
|
|
SUM(duration) AS sum_duration
|
|
FROM
|
|
page_views__v3
|
|
WHERE
|
|
documentId = {{ String(documentId, required=True) }}
|
|
AND viewId = {{ String(viewId, required=True) }}
|
|
AND time >= {{ Int64(since, required=True) }}
|
|
GROUP BY
|
|
pageNumber
|
|
ORDER BY
|
|
pageNumber ASC
|