Using user prompt to load sql data

[#1]

Hello,

I'd like to generate a document that will prompt the user (who uses the doc via the Acess Point) to insert a value.

The document shall then use this input as part of the sql statement in the script.

Example:

SELECT * FROM EMPLOYEES

WHERE EMPLOYEE_ID=$(vEMP_ID);

Can anyone help me with this issue?

[pover]

Looking at this problem at another angle, why don't you load all the employee data in your model and then reduce the data automatically through section access according to the user's username in the AccessPoint?

Regards.

[#3]

Unfortunately, it's not possible at this case as billions of records are stored in the DB and I can't load them all into the model.

[pover]

If the user uses QV Developer and could run the script, there would be no problem since you could use the input() function to receive a value for employee ID, but since the user is using accesspoint, there is no way to reload the document manually or as the user opens the document.

QlikView is not meant to do real-time queries, but rather; it is meant to consolidate data in RAM. If data volume is a problem then you will need to find a creative way of dividing the data up by QV files and linking those separate files with the help of actions, but that depends on your data and the type of reports you are creating.

Regards.