<BiQueryDefinition xmlns="http://santedb.org/bi" id="org.santedb.bi.core.query.session" label="ui.santedb.bi.core.query.session">
<add>Sample Organization</add>
<div xmlns="http://www.w3.org/1999/xhtml">
<add ref="#org.custom.dataSource.main"/>
<add ref="#org.custom.parameter.ageFilter" name="age-in-years" type="string" required="false"/>
<invariant>npgsql</invariant>
<materialize name="sample_query">
<!-- Note: Parameters cannot be used in the materialized view -->
SELECT *, age(psn_tbl.dob, CURRENT_DATE) AS age
INNER JOIN ent_vrsn_tbl USING (ent_id)
INNER JOIN psn_tbl USING (ent_vrsn_id)