cancel
Showing results for 
Search instead for 
Did you mean: 

How to build an URL to filter a variable with the # (Not Assigned) as value

Former Member
0 Kudos

Hello Gurus,

We need to build the URL that is calling a query with a filter value = #.

We need to query only those records that have "Not Assigned" in a particular Infoobject.

Example of our URL: that is not working

http://ustwa427.xxx.com:8000/sap(bD1lbiZjPTQwMA==)/bc/bsp/sap/zlabw_tempos/main.htm?INFOCUBE=CRMLORS...

You can see in VAR_VALUE_LOW_EXT_9 that we are asking for the Not Assigned values with #.

Any suggestions?

Regards,

Andrea.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Why dont you try using FILTER_IOBJNM=OBJECT&FILTER_VALUE=VALUE

http://ustwa427.xxx.com:8000/sap(bD1lbiZjPTQwMA==)/bc/bsp/sap/zlabw_tempos/main.htm?INFOCUBE=CRMLORS...

IOBJNM = Object Name (on which you want the filter)

Value = #

Something like that. Just try.

Hope it works.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

finally we found the way, is with %23.

So the URL is :

http://ustwa427.xxx.com:8000/sap(bD1lbiZjPTQwMA==)/bc/bsp/sap/zlabw_tempos/main.htm?INFOCUBE=CRMLORS...;

QUERY=ZCRMLORSEL_SELLOUTMT_Q006&

VAR_NAME_1=L_TOSALE&

VAR_NAME_2=ZLOBWCTY&

VAR_NAME_8=0S_MAT&

VAR_NAME_9=0S_MAT&

VAR_OPERATOR_2=EQ&

VAR_OPERATOR_8=EQ&

VAR_OPERATOR_9=EQ&

VAR_SIGN_2=I&

VAR_SIGN_8=I&

VAR_SIGN_9=I&

VAR_VALUE_EXT_1=3&

VAR_VALUE_LOW_EXT_8=000000000030002200&

VAR_VALUE_LOW_EXT_9=%23&

VAR_VALUE_LOW_EXT_2=CR

Regards,

Andrea.