https://community.qlik.com/t5/Talend-Studio/Check-stored-procedure-output-parameter-and-send-mail-if/m-p/2294434#M67316 Hi<BR />Save the return value into a context variable(e.g context.flag).<BR />Set condition as follow.<BR /><PRE>context.flag ==1</PRE><BR />Regards,<BR />Pedro Mon, 30 Jan 2012 08:46:46 GMT Anonymous 2012-01-30T08:46:46Z https://community.qlik.com/t5/Talend-Studio/Check-stored-procedure-output-parameter-and-send-mail-if/m-p/2294433#M67315 I call a SQLServer stored procedure that return a value using output parameter <BR />I would like to send an email if it returns 1 using "if" connector. <BR />I don't know what condition to put in the connector IF <BR />Can you help me ? Sat, 16 Nov 2024 12:25:53 GMT https://community.qlik.com/t5/Talend-Studio/Check-stored-procedure-output-parameter-and-send-mail-if/m-p/2294433#M67315 Anonymous 2024-11-16T12:25:53Z https://community.qlik.com/t5/Talend-Studio/Check-stored-procedure-output-parameter-and-send-mail-if/m-p/2294434#M67316 Hi<BR />Save the return value into a context variable(e.g context.flag).<BR />Set condition as follow.<BR /><PRE>context.flag ==1</PRE><BR />Regards,<BR />Pedro Mon, 30 Jan 2012 08:46:46 GMT https://community.qlik.com/t5/Talend-Studio/Check-stored-procedure-output-parameter-and-send-mail-if/m-p/2294434#M67316 Anonymous 2012-01-30T08:46:46Z