/*[sqlquery[*/ SELECT distinct CAST(party_identifier as VARCHAR) as party_identifier
FROM demo.acme.agreement_party_role
JOIN demo.acme.policy on agreement_party_role.agreement_identifier = policy.policy_identifier
WHERE agreement_party_role.party_role_code = 'AG'
/*]sqlquery]*/