topic Re: send alert based on row by row in QlikView

send alert based on row by row

agni_gold — Thu, 17 Mar 2016 15:23:49 GMT

Hi Experts ,

I have one straight table on which every row contains email and product , i just want to send alert email to email id with message content as its product name.

Is this possible?

gwassenaar‌

Re: send alert based on row by row

Chanty4u — Thu, 17 Mar 2016 17:10:37 GMT

chk below

One alert per row

Re: send alert based on row by row

agni_gold — Thu, 17 Mar 2016 17:26:41 GMT

it is just for customer msg , but i want to send mail for particular row which is in front of table

Re: send alert based on row by row

agni_gold — Thu, 17 Mar 2016 18:21:17 GMT

Not working

Re: send alert based on row by row

Gysbert_Wassenaar — Fri, 18 Mar 2016 07:19:39 GMT

Afaik it's not possible to send 1 alert with different messages for each recipient. You will have to create separate alerts for each row.

Re: send alert based on row by row

agni_gold — Fri, 18 Mar 2016 11:45:18 GMT

I am not sure , it is working , i have tried, .

Please help .

@SALTO can you please explain me how this is working to you.

Re: send alert based on row by row

salto — Fri, 18 Mar 2016 11:59:08 GMT

Hello Agnivesh,

In my particular case, every morning I reload a document that reads the whole Active Directory and then sends a message to the users whose password is between 50 and 59 days.

For this, I created an Alert in the document.

In the Alert, I fill the Description, Message, and Mail Subject with a standard text. I fill the Mail Recipients field like this:

=concat({$ <PasswordAge={">=50<=59"}>} mail,';')

The mail field holds the email address of the user. This sends THE SAME MESSAGE to all the users (I have not found a way to include the PasswordAge in the message body), so I am not sure this is what you are looking for.

Regards.

Re: send alert based on row by row

agni_gold — Fri, 18 Mar 2016 14:40:19 GMT

Thanks Salto ,

Actully i was looking for related value in message body.

(I have not found a way to include the PasswordAge in the message body)

I thinks it is not possible

What you think?

Re: send alert based on row by row

salto — Tue, 29 Mar 2016 07:16:11 GMT

Hi Agnivesh,

sorry for the delay, I have been disconnected for several days.

Regarding your question, I have not been able to personalize that message, and as Gysbert says below, "Afaik it's not possible to send 1 alert with different messages for each recipient. You will have to create separate alerts for each row"

Seems not to be possible by now...

Regards.

Re: send alert based on row by row

agni_gold — Tue, 29 Mar 2016 07:24:32 GMT

Thanks

Re: send alert based on row by row

agni_gold — Tue, 29 Mar 2016 17:39:26 GMT

Hi gwassenaar‌

Is there any other way to do this like any batch or any other way to do this.

Please guide.

Thanks

Re: send alert based on row by row

Gysbert_Wassenaar — Wed, 30 Mar 2016 05:37:56 GMT

Yes. Buy or create a tool that monitors and analyses the log files as they are created and that sends emails according to the conditions you supply that tool.