Skip to Content

Dynamic Alerts

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2011 at 10:44 AM


    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?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 30, 2011 at 07:02 AM

    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...

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.