Issue with email notification containing empty variable values from Request Item

[Rhonda9]

I created a querie business rule to restrict request items that belong to a data group to only that group.  The querie is working as expected with the exception of when an email is triggered from creation of request item, the requested for and request item fields are blank when receive email notification.   This is only happening with the request item that I created a before business rule for.   When I make the br inactive, and create a request item the fields are populated on the notification email. 

Any guidance on this would be appreciated.... 

Requested Item and Requested for is blank 

[AshishKM]

Hi @Rhonda9 , 

Keep the BR inactive and utilize the ACLfor group specific access.

or allow the system user/role to query on the ritm table in BR script. 

-Thanks,
AshishKM

[Mark Manders]

Is this an email send to a user with access to the data in the ticket, or not? 
And how are you triggering the email? Through flow designer or directly in the email notifications?

[Rhonda9]

It is an oob email notification using a script.  This works fine for the other Request Items but somehow the querie business rule I created is causing the issue with the Sensitive Data Request. 

[Ankur Bawiskar · Accepted solution]

@Rhonda9 

please ensure you add this in your query BR condition along with your existing condition

gs.getSession().isInteractive()

If my response helped please mark it correct and close the thread so that it benefits future readers.