Page 2 of 2

Re: How to use the Query In function

Posted: Mon Feb 18, 2019 11:05 am
by 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.

Re: How to use the Query In function

Posted: Tue Feb 19, 2019 10:20 pm
by Lech Kulikowski
Hello,

Which designer, viewer do you use?

Thank you.

Re: How to use the Query In function

Posted: Wed Feb 20, 2019 1:45 pm
by Martijn
I use the 'Stimulsoft Reports V 2019.1.1 from 17 december 2018' it is the Apple version.

Re: How to use the Query In function

Posted: Thu Feb 21, 2019 11:52 am
by Lech Kulikowski
Hello,

Is NET, Web, JS, HTML5 etc?

Thank you.

Re: How to use the Query In function

Posted: Thu Feb 21, 2019 1:58 pm
by Martijn
Oeps, sorry.
It is the .JS Version.

Re: How to use the Query In function

Posted: Fri Feb 22, 2019 12:40 pm
by 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.

Re: How to use the Query In function

Posted: Tue Feb 26, 2019 8:34 am
by 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.

Re: How to use the Query In function

Posted: Tue Feb 26, 2019 10:29 pm
by Lech Kulikowski
Hello,

Thank you for the provided solution.