Hello,

How can I do this query by formulas to apply on business process?

select c.Email from SysAdminUnit aunit

inner join SysUserInRole urole on urole.SysUserId = aunit.Id

inner join Contact c on c.Id = aunit.ContactId

where urole.SysRoleId in

(select aunit.Id  from SysAdminUnit aunit

where

(aunit.name = 'Head of Customer Services' or

aunit.name = 'Cash Ops Manager' or

aunit.name = 'Operations Team Leader'))

Thank you