nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Passing Multiple values in a Parameter

Saranya · 2015-08-12T04:57:10+00:00

Dear All, I want to pass a parameter in the In clause. I need to key in the values in the parameter text box as shown below format. P124,T300,E234,D844 Mostly the count of the values that I give would be around 50 - 100 records. Can someone help me here on how can I…

Saranya

Dear All,
 
I want to pass a parameter in the In clause. I need to key in the values in the parameter text box as shown below format.
 
P124,T300,E234,D844
 
Mostly the count of the values that I give would be around 50 - 100 records.
Can someone help me here on how can I give those values in the parameter test box

Find more posts tagged with

Comments

micajblock

You will need to manipulate the string as the IN clause will require quotes. The DevShare has a similar solution and should give you an idea. 
 
<a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/722-using-a-multivalue-parameter-in-a-in-clause/'>http://developer.actuate.com/community/forum/index.php?/files/file/722-using-a-multivalue-parameter-in-a-in-clause/</a>

Saranya

Thank you. I tried this and it worked for me too. But this works only when I have a dynamic dataset created and with this solution ,i will only be able to select multiple options which are there in the parameter selection.
 
In my case I would like to give more than 1 input value in the parameter text box and the above solution suggested is not working for that.

micajblock

It is exactly the same thing. The only difference is you need to convert the comma delimited string to an array first. See attached example.

Saranya

Great.. Thank you so much. It worked out for me

zer0

Thanks to this post its save my day . thanks again