Skip to content

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

411 B
Raw Blame
VERSION 1

NODE endpoint
SQL >
    %
    SELECT SUM(duration) AS sum_duration, COUNT(distinct viewId) as view_count
    FROM page_views__v3
    WHERE
        linkId = {{ String(linkId, required=true) }}
        AND time >= {{ Int64(since, required=true) }}
        AND documentId = {{ String(documentId, required=true) }}
        AND viewId NOT IN splitByChar(',', {{ String(excludedViewIds, required=true) }})