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 0

Like

1 comments

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

Show all comments