Skip to Content
0
Feb 01, 2007 at 09:30 AM

Passing Filter values for free characteristics for 04s Query in URL

24 Views

Hi,

can anybody tell me the syntax for passing filter values in URL for a query. I can pass variable values with this syntax:

Query = ZA7401

Variable1 = 0P_CALYE with value = 2006

Variable2 = 0P_CALMO with value = 12

http://SERVERNAME:PORT/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!2fcom.sap.pct!2fplatform_add_ons!2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.bi.bex?QUERY=ZA7401&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=2006&BI_COMMAND_2-BI_COMMAND_TYPE=SET_VARIABLES_STATE&BI_COMMAND_2-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=0P_CALMO&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=12

I have tried to pass filter values for free characteristics but the query raises no error but also doesn't takes the filter:

Query = ZA7401

Variable1 = 0P_CALYE with value = 2006

Variable2 = 0P_CALMO with value = 12

Free Characteristic = ZORTSCODE with value = 5318

http://SERVERNAME:PORT/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!2fcom.sap.pct!2fplatform_add_ons!2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.bi.bex?QUERY=<b>ZA7401</b>&BI_COMMAND_1-BI_COMMAND_TYPE=SET_VARIABLES_STATE&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=<b>0P_CALYE</b>&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=<b>2006</b>&BI_COMMAND_2-BI_COMMAND_TYPE=SET_VARIABLES_STATE&BI_COMMAND_2-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=<b>0P_CALMO</b>&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=<b>12</b>&BI_COMMAND_3-BI_COMMAND_TYPE=SET_SELECTION_STATE_SIMPLE&BI_COMMAND_3-CHARACTERISTIC=<b>ZORTSCODE</b>&BI_COMMAND_3-RANGE_SELECTION_SIGN=INCLUDING&BI_COMMAND_3-RANGE_SELECTION_OPERATOR=EQUAL_SELECTION&BI_COMMAND_3-RANGE_SELECTION_OPERATOR-EQUAL_SELECTION=MEMBER_NAME&BI_COMMAND_3-RANGE_SELECTION_OPERATOR-EQUAL_SELECTION-MEMBER_NAME=<b>5318</b>

Thank you for any help.

Best Regards,

Murat Y.