I'm gathering a list of IDs in my Project which I'm currently forming into a comma separated list "listOfIDs" and then at the end I'm looking to pull records from the database based on the list.

So listOfIDs looks like this: 56347,75647,23467

select a,b from tablex where id in (?)
parameter 1: ${listOfIDs}

Normally in Java I would pass this list in as an array and I see array as an available datatype in the parameter but am not sure how to form the data into an array. Not sure the best route on this.