Formulas in Business Process

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