Dynamic Alerts

[tomasz_staro]

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.

[tomasz_staro]

That's not what I meant. My goal is to make ONE alert with ONE query for MULTIPLE users but each one of them should receive another result of this query. There should be kind of @user parameter it this query but where can I get a value for it from? Alert queries execute without user action and I suppose a $[user] variable will not work...

[former_member204969]

I think it is impossible. The system executes the alert query at the specified times and send the result to the listed users. One alert once (without knowing who will be the recipient) without any parameter.

[Former Member]

HI

You can use "owner" of the field in each document.

You can put a where condition for the 'owner' field and design the query...

So you can filter the document according to the user by the owner field....

Got it?