If the Site value is free text to be entered, I think you can enter multiple values with a separator, but the exact syntax is eluding me as I try to check with a similar example here.

Nick

It is eluding me as well, when ever it seems so simple it is so hard ha ha ha

I can get it to work when using an IN( ) statement, for example:

Parameter value entered: 12,13

Data Source condition is: company in($COMPANY$) AND objstate <> 'Paid' AND cancelled <> 'TRUE' AND  ….<blah>

This will return relevant results for both company 12 and 13.

I would think you could adjust your code to function similarly.

HTH,

Nick

I have it written like this

CONTRACT IN ('$SITE$') and

But this is what i get from my element when i try to put C0158,C0152 on the lobby page

Syntactically that will be resolving into IN (‘C0158,C0152’) which is really just a single value in the quotes.

If they were just numbers you would drop the ‘ character completely (which is what I have in my example).  That may not work for a list of values that are text strings but you could try it.

A simple workaround would be to enter the values as ‘C0158’,’C0152’ and also drop the ‘ in the expression that you have coded, so that it resolves to IN (‘C0158’,’C0152’) and will likely parse as you intend.  Its a little clunky and there may be a better syntax but this should work for you

thank you looks like it will work for what i am trying to do. Thank you again

Hi Rpauley,

i would like to suggest you that you can use below code in data source where you can pass multiple site with comma separated. hope it will addressed your query.

AND CONTRACT IN ( select regexp_substr('$SITE$',''^,]+', 1, level) from dual
    connect by regexp_substr('$SITE$', ',^,]+', 1, level) is not null )

Regards,

Ashok