You may find that batching all of those statements up into a stored
procedure and calling that will work as you require.
You will need to set the script options to allow write (QlikView assumes
any stored procedure may write to the database).
You should find instructions for this if you search the community.
The query I am trying to run is as follows:
from MSC_EXCEPTION_DETAILS_V MD
where MD.PLAN_ID = 1
and MD.EXCEPTION_TYPE_TEXT='Items with excess inventory'
MSC_EXCEPTION_DETAILS_V is a seeded view in Oracle.
when removing MD.EXCEPTION_TYPE_TEXT='Items with excess inventory', it's working fine.
Anyone does have any inputs for local machine setup?
Try without the WHERE statement and then after load add a list box to the
screen containing MD.EXCEPTION_TYPE_TEXT. This will show you all values for
this field. Find the list box entry and check it matches your WHERE
statement. You can right click it and select 'Copy Cell Value' and paste it
into your load script.
If that value doesn't exist then you have found your problem. I would then
head back to the database to investigate. Or you could comment out the
other two WHERE statements to check three full table contents in QlikView.
Hope that helps,