hi all.
I am making a call to a query from Visual Composer to them I am
occupying the following code:
http://server:50000/irj/servlet/prt/por ... 0050_Q0045
&BI_COMMAND_1-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=0P_CALYE
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_INPUT_STRING
&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_INPUT_STRING=VALUE_ZYEAR
&BI_COMMAND_2-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_2-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=Z0COSCENTER_0ORGUNIT
&BI_COMMAND_2-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_INPUT_STRING
&BI_COMMAND_2-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_INPUT_STRING=VAL_ZORGUNIT
&BI_COMMAND_3-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=0P_CALMMO
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_INPUT_STRING
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_INPUT_STRING=VALUE_ZMONTH
So far so good, I can run the querys without problem.
But when attempting to call a query that has as an input variable
interval, I failed to find the way to go.
Someone could give me some indication about it, what would be the way
called an interval.
The input variable for the quey is used for the feature 0CALMONTH2 (0P_CALMO - ZDATE_END)
I tried using the following alternatives, all with no luck:
alternative 1:
&BI_COMMAND_3-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=0P_CALMO - ZDATE_END
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_INPUT_STRING
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_INPUT_STRING=VALUE_ZMONTH1 - VALUE_ZMONTH2
alternative 2:
&BI_COMMAND_3-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=0P_CALMMO
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_INPUT_STRING
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_INPUT_STRING=VALUE_ZMONTH1
&BI_COMMAND_4-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_4-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=ZDATE_END
&BI_COMMAND_4-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_INPUT_STRING
&BI_COMMAND_4-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_INPUT_STRING=VALUE_ZMONTH2
search within to achieve the following code, but I've tried
managed to find the right way to use it, any suggestions?
&BI_COMMAND_3-BI_COMMAND_TYPE=SET_VARIABLES_STATE
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=INFO_OBJECT_MEMBER_VARIABLE
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-INFO_OBJECT_MEMBER_VARIABLE-SELECTION_1=INTERVAL_SELECTION
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-INFO_OBJECT_MEMBER_VARIABLE-SELECTION_1-INTERVAL_SELECTION-INTERVAL_SELECTION_LOW_MEMBER=MEMBER_NAME
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-INFO_OBJECT_MEMBER_VARIABLE-SELECTION_1-INTERVAL_SELECTION-INTERVAL_SELECTION_LOW_MEMBER-MEMBER_NAME=VALUE_1
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-INFO_OBJECT_MEMBER_VARIABLE-SELECTION_1-INTERVAL_SELECTION-INTERVAL_SELECTION_HIGH_MEMBER=MEMBER_NAME
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-INFO_OBJECT_MEMBER_VARIABLE-SELECTION_1-INTERVAL_SELECTION-INTERVAL_SELECTION_HIGH_MEMBER-MEMBER_NAME=VALUE_2/b]
&BI_COMMAND_3-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=[b]¿?
from now thanks for your help
Manuel