I have two tables
I have a the following columns in the note table relevant to what I want to achieve and the notes are in a deck view.
-Captures the email address of the user creating the note.
CC Users Column:
-Is a enumlist linked to the list of users in the user table where the note owner can select multiple user names to be used to lookup the relevant users email address to be used in a security filter.
-indicates a populate list of users who open the note from deck view to detail view.
I would like 2 slice deck views that I would like to setup security filter that only list either the note owner or relevant User in CC.
1.1 Note Owner
1.2 CC Users
How do I get the Read By column to populate a list of users that open up the relevant deck view to detail view.
So the idea is that I will end up with the following filtered views.
All Notes By Owner
Unread Notes By Owner
All Notes By CC
Unread Notes By CC
Any ideas on how to achieve this?
Are there perhaps any sample app and or other threads available that replicate what I would like to achieve?
Thanks for the help in advanced.