Using List Type Variable in query

Stimulsoft Ultimate discussion
Post Reply
harundemir13
Posts: 28
Joined: Thu Aug 01, 2019 1:22 pm

Using List Type Variable in query

Post by harundemir13 »

Hello,
I am using a list type variable in the report. I can filter the report while I wrote the variable.Contains() expression to DataBand Filters. I want to use this structure in data source query. I tried this solution but it didn't work.

Thank you,
Lech Kulikowski
Posts: 6266
Joined: Tue Mar 20, 2018 5:34 am

Re: Using List Type Variable in query

Post by Lech Kulikowski »

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.
harundemir13
Posts: 28
Joined: Thu Aug 01, 2019 1:22 pm

Re: Using List Type Variable in query

Post by harundemir13 »

Hello,
Sorry for the late reply. I found something and I tried, it worked. This script part is in Edit Data Source.
{var1.Count == 0 ? "" :"where id in ("+var1.ToQueryString("'")+")"}
Thanks.
Lech Kulikowski
Posts: 6266
Joined: Tue Mar 20, 2018 5:34 am

Re: Using List Type Variable in query

Post by Lech Kulikowski »

Hello

Ok.
Please let us know if you need any additional help.

Thank you.
Post Reply