I am trying to pass a parameter that contains multiple values to open an on demand table.

[Manoj Chaurasia]

I am trying to pass a parameter that contains multiple values to open an on demand table. If I pass a single value everything works. How can I pass more than one value in a parameter

[Manoj Chaurasia]

Are you using a stored procedure in Info link

[Manoj Chaurasia]

https://tibbr.tibcommunity.com/tibbr/#!/messages/129064

Open this link. this has the code for setting property from marked.

[Manoj Chaurasia]

yeah . that is it .

[Manoj Singh]

You can define input of your existing on-demand data table by Edit Menu>>Data Table Properties>>Select On-Demand Table >>Settings.Now you can set/define the input accordingly.

[Abhishek Singh 7]

I guess , you are creating an infomation link , in edit sql option , in place of = , put in , for eg , where [column_name]=value, put where [column_name] in (value)

[Manoj Chaurasia]

Thank you both, but I am having issues getting the parameter passed FROM Table A to contain multiple values. I can configure Table B's input without issue, but If I mark more than one item in table A only 1 value is passed. I want to pass an array of all of the values I mark in table A (for the input column in table B)

[Abhishek Singh 7]

yes , putting an "in" in the sql of table B will work , you must have defined input for the input column for Table B as the value from column of Table A, If you select more than one records from table A , all the input column values will go in the sql like where [TableBcolumn] in ('value1', 'value2')

[Sushank Goel]

Also in the Parameter you have created in Information link , Value Type should be of : Array as shown in attached screenshot.

[Abhishek Singh 7]

yeah forgot that . thank Sushank,

[Manoj Chaurasia]

I have set the parameter as an array and spotfire is still only passing a single value. I have verified this on the Sql logs. Would you know how i can pass my marked rows to a property

[Abhishek Singh 7]

What exactly happens when you mark multiple rows in table ADo you see an error notification may be you are missing something somewhere .

For passing marked rows to Property , u can refer to the following link

http://gabeortiz.com/posts/set-property-from-marked/

[Manoj Chaurasia]

Abhishek- The website is dead :( I would love to see the instructions though.

As for what happens when I mark multipe rows, only the first parameter is passed. No errors are thrown. The SQL Log looks like this:

{ call "mydatabase"."mschema"."mystoredproc"('01AA1FC576FD4D4096B19D0727137C8D') }

I am expecting to get something like this:

{ call "mydatabase"."mschema"."mystoredproc"('01AA1FC576FD4D4096B19D0727137C8D','12341FC576FD4D4096B19D0727136589','45671FC576FD4D4096B19D0727135421','98761FC576FD4D4096B19D0727133214') }

[Manoj Chaurasia]

I appreciate the help. The link os dead but i have figured it out. Basically i populate a property with my marked values and pass that property to my stored proc

[Victoria M]

instead of having

ID = Parameter

put

ID in(Parameter)