Dynamic Updates on Server

[#1]

Hi All,  I have a file with text boxes having Dynamic Update action which works great on my system. But the updates stop happening after deploying it on the server. I have checked all the options for allowing dynamic update inside the file, as well as the options in server QV Management Console. Does anyone have a clue why this may be happening. Do I require a special license for allowing updates on the server. I'm using QV version 11.20

Thanks !

[fkeuroglian]

Hi, are you using macro?

what browser are you using?

check all the image attached and sure that the propertys are ok

Good luck

Fernando

[#3]

Thanks for replying Fernando. I am using Internet Explorer and all the properties in the images are enabled. I'm not using a macro, I have a text box with the update statement written in the 'Dynamic Update'  action of the text box. It works in the desktop mode and Web view, but not on the server.

[fkeuroglian]

Varun, Macro could be an option

example attach

Good luck

Fernando

[#5]

Hi Fernando, I realized that my Dynamic update statement has the '>=' condition which does not work on the server.

My statement is:

UPDATE Data_Table SET Limit_Interest=$(vUserLimit) WHERE Limit_Date >= '$(vUserDate)';

= condition works on the server, but <= or >= don't work. I need to use >= , do you know any way to get it working, probably by changing the statement syntax.

Thanks

[fkeuroglian]

Hi, try to separate?

UPDATE Data_Table SET Limit_Interest=$(vUserLimit) WHERE Limit_Date >  '$(vUserDate)' or Limit_Date = '$(vUserDate)' ;

separate >= in > or =

would be an option

[#7]

Hi Fernando, Thanks for the suggestion, but even the separate symbols do not work. I also read here (BI Review: Using Dynamic Updates in QlikView 11)  that only the = condition works in dynamic updates. I tested my file with > which updated data in the desktop QV but not on the server.

[jerrysvensson]

Why not create vUserDateMinusOne = vUserDate -1 day?

Then:

UPDATE Data_Table SET Limit_Interest=$(vUserLimit) WHERE Limit_Date > '$(vUserDateMinusOne)';

BTW, have you verified with a basic test that your Dynamic update actually works on server?

The user has be part of the QlikView administrator group.

[maleksafa]

hi,

the dynamic update requires a high level of permissions for the users to execute it from the web (access point), the user must be in the 'QlikView Administrator' group.

[Bill_Britt]

Hi,

Do you have the below in your LEF?

DYNAMIC_UPDATE;YES;;

Bill