I have scenario where I have a user record which is linked to a Tenant by a Tenant ID. I want to only display notifications to the Tenant user on a portal where where their tenant ID is part of a multi-select field of recipients of the alert notification. I am struggling with the query of the repeating group on the portal side. I tried using the intersect function but I think that only works if you are comparing two lists. In this case I am comparing a user record field to a multi-value field in another table.
First name: Jane
Last name: Smith
Tenant ID: 1234
Alert notification table: (Recipients is the multi-value field)
Communication title: Welcome notification
Communication body: Test alert notification
Recipients: 9876, 5432, 1234
I would want the repeating group to show only alert notification records where the current user’s tenant ID is in alert notification’s recipients.
Thanks in advance!