I'd like to have an array as a parameter for a SQL 'WHERE... IN' statement. The array would be modified in javascript on the browser. Here's a simplified example:
<tablePane width="25%" id="testTable" sql="SELECT Id from Tracking_Data.Person WHERE Id IN (?)" showQuery="true">
<parameter/>
</tablePane>
<button caption="Test" onclick="zenThis.composite.testTestTable();"/>
ClientMethod testTestTable() [ Language = javascript ]
{
var table = zenThis.composite.getChildById("testTable");
table.setProperty('parameters', 1, [1,2]);
}
However, I've noticed that when Zen takes in the parameter it treats the array [1,2] as the number 12. The same happens with the string "1,2". See the attached picture.
Is there any way to use a table parameter for a WHERE… IN statement?