Report: Hello world Query

Example Usage

SELECT * FROM community.report(NULL::community_types."@wisdom/developing/all-together",
_project_id => ?
);

Report Context

Context

Here we take a community report and left join it on the person table to add two columns, the person's name and email.

Report Definitions

Input Parameters

Name
projectid

Output Record Type

NameType
nametext
emailvarchar255
projectIdinteger
sessionStarttimestamptz
identityIdvarchar80
timezoneIANAvarchar255
countryCodevarchar4
browserNamevarchar32
activeTimeinteger

SQL Report Query

SELECT
person."firstName" || ' ' || person."lastName" AS name,
person.email,
session.*
FROM
report(
NULL::community_types."@wisdom/developing/passing-parameters",
_project_id => ($1->>'_project_id')::INTEGER
) AS session
LEFT JOIN atomic.person
ON
person."identityId" = session."identityId" AND
person."projectId" = session."projectId"
Last updated on by John Gracey