I have a use case to list the tickets assigned to a user in Power pages. I am using OOB list control and showing data from view.
I have a primary assignee column which looks up to contact table. I have used Portal Attribute filter condition option to show only tickets assigned to the logged in user and this is working fine
Now I have a use case where I need a new column secondary assignee which again looks upto contact table.
So when a user logs in, he should see tickets where he is either a primary or secondary assignee.
How do I achieve this? How to filter against multiple columns based on logged in user.