Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

how to call stored procedure and pass parameter as a selected date

Hi,

How to execute stored procedure in qvw file and  pass selected date as a parameter to that storded procedure

Administrator

2 Replies
Partner
Partner

Re: how to call stored procedure and pass parameter as a selected date

Hi,

you can follow this syntax:

first you have to create a variable for each parameter you need to pass to the Store Procedure. In this example, let's suppose you just have a single date parameter:

let vDate = '2013-01-01' //here is important to use the same format that is used in the database

Store_Procedure_table:

Load * ;

SQL EXECUTE DB.OWNER.STORE_PROCEDURE '$(vDate)'; //with the last part you're passing the needed parameter

If you had several parameters you can separate them with commas and alwas with the $-expansion and between single quotes,

regards,

Highlighted
Employee
Employee

Re: how to call stored procedure and pass parameter as a selected date

SQL EXECUTE ProcName 'param1', 'param2';