topic Re: I need to create an alert on this sql code in QlikView

I need to create an alert on this sql code

Thu, 17 Jul 2014 19:49:26 GMT

I need to create an alert on this sql code I believe it uses bitwise operators, I don't know what that is at all but I was wondering If I can create an alert on this and if someone can help me explain to me the sql code it self, select * from Roles where roletype=0 and (supervisor1 & 4096)<>0 so if this comes back with a row I need to send an alert out with relevant data. or something that says alert. select * from UserAllPermissions where DepartmentID =0 and (supervisor1 & 4096)<>0 same thing with this one. there are multiple but if you can explain to me what to do on qlikview and if this can be implemented I would appreciate it if you can let me know.

Re: I need to create an alert on this sql code

fkeuroglian — Thu, 17 Jul 2014 21:31:16 GMT

Hi,

what kind of alert? explain more or put an example to be easier help you

alert what could be? a flag in the script?

coulb be to send mail and notice that the condition its true

could be many ways

tell me more please to help you

Fernando

Re: I need to create an alert on this sql code

Thu, 17 Jul 2014 21:34:33 GMT

my apologies I meant an alert like an email that can be sent out or even a message on the screen when the condition is meant. I honestly don't understand this condition but when I run it on the database it does pull a row out.

Re: I need to create an alert on this sql code

Siva_Sankar — Fri, 18 Jul 2014 03:11:07 GMT

check out document with steps to implement alert and email sending in qlikview.

CREATING AUTOMATED ALERTS AND EMAILS SENDING BASED ON DATA LOADED IN QLIKVIEW.docx