Caller is not (dynamic) one of my Assignment group

Alon Grod
Tera Expert

‎02-18-2023 09:23 AM

Hi,

 

I have the field 'hide_incident' of type True/False. 

I need to write a BR query on the incident table that will meet these 2 conditions:

 

1) hide_incident = True

2) caller and login user are not in the same assignment group.

 

How can I achieve that?

 

 

0 Helpfuls
  • 596 Views
11 REPLIES 11

Saurabh Gupta
Kilo Patron
Kilo Patron

‎02-19-2023 02:09 AM

Hi @BharathChintala 

 

As per your suggestion script will not complicated but the execution time is worst.

You know query BR will run on each row of the table. This kind of script will be a nightmare.

 

 


Thanks and Regards,

Saurabh Gupta

BharathChintala
Mega Sage
In response to Saurabh Gupta

‎02-19-2023 02:33 AM - edited ‎02-19-2023 02:34 AM

@Saurabh Gupta  That is the reason I gave solution of ACL.

 

With before script I have explained cleared checking tables and returning numbers and building query is complicated and gave other option as ACL with full working script and steps. As a developer hope they understand which one to pick.

If my inputs have helped with your question, please mark my answer as accepted solution, and give a thumb up.
Bharath Chintala