BI Publisher Workflow Notification – Show/Hide Fields Based on Logged-In User for Notifications

Summary:

Hi,

I’d like to know if it’s possible to configure a BI Publisher Workflow Notification to dynamically display or hide certain fields based on conditions related to the logged-in user.

Specifically, I’d like to apply some SQL-based logic (or equivalent configuration) so that a field in the notification is only visible if:

• the person viewing it has a specific role, or
• a certain flexfield in their job (position) contains a particular value.

I’ve already used conditional logic to show or hide information based on data from the transaction itself (for example, displaying text only if the salary is greater than a certain amount).However, I’d like to confirm whether there’s a supported way to reference or evaluate the