I have an agent that runs and creates a trouble ticket out of freeform emails that are sent to a mail database. This agent looks at a view and creates a ticket for every document in the view.
The view is already limited to certain criteria, and I want to add the criteria that the email sender (Principal) can not be a member of the MIHD group in the Address Book. I can’t do a DBColumn or DBLookup in the view selection criteria … short of hard-coding all the names in the MIHD group, is there another way?
The way I would do it is to load all the members of the group into a list, then when processing the email, if the user is a member of the list, don’t send it.
naturally, you will have to expand groups, and groups with groups should you allow it. However these are posts in here that should point you to the way.
Yes. So the person who created the document is in your group, so it will be in the view. When you process the document, if they are in the group, then you mark it as being processed (So it drops from your view).
This way you never have to modify the code again when somebody gets added/delete from your exclude group. You could even mark the document as not getting a ticket since it was a person in the group.