on 06-18-2013 7:44 PM
I am trying to use the application.setvariableValue in the onselect event for a date field. After the date is entered, the query should execute and the values in the crosstab should change. However the data is not changing.
the following is the code in the onselect event:
datefilter = DATEFIELD_1.getDate();
APPLICATION.setVariableValue("0P_KEYDT",datefilter);
is there a step I am missing. I am executing locally.
thanks for the help.
Make sure you pass the date in the correct format of the variable and internal or external type. Date from the DATEFIELD component is of the format YYYYMMDD. It should work fine.
Here is an example: In my case I use CALMONTH variable and the script used is
var varMonth = Convert.subString(DATEFIELD_1.getDate(), 4,6) + "." + Convert.subString(DATEFIELD_1.getDate(), 0,4);
APPLICATION.setVariableValueExt("VAR_CALMONTH_USER", varMonth);
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.