I have to make an Alert for a client which shows a result of one select query. It can list Invoices or Orders, it doesn't matter. The problem is it have to be send to about 20 users and each of them should get a list of his/her own documents only. I could make 20 alerts with 20 selective queries - one per user but it doesn't seem best solution especially when new users appear.
The question is: Is there a way to make DYNAMIC query-Alerts so the result of query would be dependant of the user the alert is send to?
I've tried to make a query joined with alert tables but it didn't work. I appreciate any ideas.