mirror of
https://github.com/hanzo-apps/dataroom.git
synced 2026-10-30 14:47:36 +00:00
18 lines
413 B
Plaintext
18 lines
413 B
Plaintext
VERSION 1
|
|
|
|
NODE endpoint
|
|
SQL >
|
|
%
|
|
SELECT
|
|
viewId,
|
|
SUM(duration) AS sum_duration
|
|
FROM
|
|
page_views__v3
|
|
WHERE
|
|
dataroomId = {{ String(dataroomId, required=true) }}
|
|
AND time >= {{ Int64(since, required=true) }}
|
|
AND linkId NOT IN {{ Array(excludedLinkIds, String) }}
|
|
AND viewId NOT IN {{ Array(excludedViewIds, String) }}
|
|
GROUP BY
|
|
viewId
|