I am stuck writing a query for a notification

[bcksf]

Hello,

I am trying to write a notification for a New User Request that has not been assigned.

I would like the notification to go to the team email that is responsible for the service of which the the User Request is tethered to.

I'm not sure how to write such a query. If someone could help me out, I would be most obliged.

[dlp]

Maybe something like this :

SELECT Contact AS c
JOIN lnkContactToService AS lcts ON lcts.contact_id=c.id
WHERE lcts.service_id=:this->service_id AND c.finalclass='Team'

[bcksf]

This looks right. Thank you so very much.