How to pass parameters to a store procedure through Qlikview Ajax client.

[lalitinmbd]

Dear All,

I have came across a requirement which is described below:

User want to pass the parameters in to a store procedure and then run the store procedure to get the data (on the basis of parameters we passed in to SP). This functionality should be available to all the users accessing the application through theer web browsers??

Thanks  in Advance.

Regards

Lalit Chaudhary

[Clint_Carr]

I would query why you have this requirement.

QlikView stores all data in its own data store,  upon opening an application the Server loads the QVW into RAM.  It does not then query the original data source.  The performance when reading from RAM far surpases querying from the data source.

If you need to do something along these lines you would most likely have to create an extension object.

Alternatively,  if you can query a single table I would direct you to Direct Discovery functionality.

Clint

[tresesco]

To be able to do similar, you have to look for EDX or macro solution I believe. See:

• Re: running macro for document reload
• Using EDX in QlikView 11