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