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
Like
Dear Carolina,
I don't think that you would be able to do that in a formula. You can do this in a script task though. You can either use a Select class: |https://academy.creatio.com/documents/technic-sdk/7-15/retrieving-information-database-select-class
Also you can use EntiySchemaQuery:
https://academy.creatio.com/documents/technic-sdk/7-15/introduction-10
Best regards,
Dennis