Skip to Content
avatar image
Former Member

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

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=CRMLORSLM&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=#&VAR_VALUE_LOW_EXT_2=CR

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

Any suggestions?

Regards,

Andrea.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 10, 2008 at 04:49 PM

    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=CRMLORSLM&QUERY=ZCRMLORSEL_SELLOUTMT_Q006&FILTER_IOBJNM=OBJECT&FILTER_VALUE=VALUE

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

    Value = #

    Something like that. Just try.

    Hope it works.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 10, 2008 at 05:03 PM

    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=CRMLORSLM&

    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.

    Add comment
    10|10000 characters needed characters exceeded