Report with Multi-Select

Ignition
1

I am trying to create a report against MSSQL with a basic in clause.

I can create a row selector in the UI to create the dataset of values to pass to the report parameters, but then getting a dataset into the IN clause of the SQL Query seems impossible. Does anyone have any examples of this?

SELECT 
  *
FROM 
  table t
WHERE
  t.name IN (?)

I want to be able to pass the Dataset parameter directly to the Query. Ex: {NameValues}

2

You cannot. You’ll have to generate this dataset in a script, creating the SQL on the fly with the correct number of ‘?’ placeholders.

3

:frowning:

I can understand how to do that from scripting, but any ideas on how to prepare that for the reporting module?

4

Use a Script Data Source. If you need to do nesting from there, see this topic.

1 Like