Skip to content

Papermark is the open-source DocSend alternative and secure data rooms with built-in analytics and custom domains.

467 B
Raw Blame
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 time <= {{ Int64(until, 9999999999999) }}
        AND linkId NOT IN {{ Array(excludedLinkIds, String) }}
        AND viewId NOT IN {{ Array(excludedViewIds, String) }}
    GROUP BY
        viewId