How to use the Query In function

[Martijn]

For a new Report i added a new Data Sources -> Select MYSQL and added the connection string.

Server=localhost; Database=testdata;
UserId=root; Pwd=;

And set all the tables and variables.

The same i do with your ListInQuery Example.
I download the file and open it in the program. I change the Data Source en nothing else.
I have the same databaseName with one table with same name as in your example. And the same data in the database.

Maybe the table column is wrong in the database itself?
I added a .sql attachments with the testdata.

[Lech Kulikowski]

Hello,

Which designer, viewer do you use?

Thank you.

[Martijn]

I use the 'Stimulsoft Reports V 2019.1.1 from 17 december 2018' it is the Apple version.

[Lech Kulikowski]

Hello,

Is NET, Web, JS, HTML5 etc?

Thank you.

[Martijn]

Oeps, sorry.
It is the .JS Version.

[Lech Kulikowski]

Hello,

Unfortunately, in the JS, at the current moment, is not supported. We have added this task to our to-do list.

Thank you.

[Martijn]

Ok.

After a long search i find the solution for my problem.
I now use the FIND_IN_SET() function into the 'Data source query' like so : 'FROM table WHERE FIND_IN_SET(code, '{var1}')'
This also means that the var2 variable is not needed anymore.

[Lech Kulikowski]

Hello,

Thank you for the provided solution.