Skip to Content
avatar image
Former Member

Optional Input Parameter with multiple values

Hi,

We defined Optional input parameter with multiple values for a material in graphical calculation view

If we don't select any material in the filter then it should return all the materials or it should get only the materials if we enter  the material in the filter.

for this in the filter expression we are using the below syntax

in("MATNR",'$$IP_MATNR$$') or match ("MATNR",'*$$IP_MATNR$$*') .



With this expression we are getting syntax error.


Can any one help how to write filter expression for this requirement.



Thanks

Srini

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 09, 2016 at 02:31 AM

    Hi Srini,

    That expression will work if you have used "Single Value" ( unchecked "multiple values" )..

    If you need a expression to work with multiple values then you have to use like below :

    in("MATNR",$$IP_MATNR$$) or match ("MATNR",$$IP_MATNR$$)
    


    And then you can send '*' to get all values .


    SELECT *
    FROM "_SYS_BIC"."<CV_NAME>"('PLACEHOLDER' = ('$$IP_MATNR$$', '''*''')) 
    


    Regards,

    Krishna Tangudu

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Krishna Tangudu

      Hi Krishna,

      Thank you for your time/response.

      'Match' function is working fine with single input parameters, incase of multiple input parameters, if i use 'match' on all and if I pass value to one parameter and left another one blank, still system bringing all values.... ( Ideally, system should fetch data based on parameters entered only,.. just like BEx variables or any other variables)

      ex - i have two parameters year and customer. If i pass customer value and left year as blank, system should fetch data for that customer for all years.