Does Reports.Fx for Java 2016.1 support request by user variable of the list type in SQL query?
e.g:
Code: Select all
select * from table where name in '{var1}'
Code: Select all
select * from table where name in '{var1}'
Code: Select all
select * from table where name in ('{var1}')
Code: Select all
select * from table where name in ('[b, d, g, f, e, c, a]')
Code: Select all
select * from table where name in ('[b, d]')
Code: Select all
select * from actor where actor_id in ({Substring(ToString(Variable1), 1, Length(ToString(Variable1)) - 2)})
HiVadim wrote:Hello.
You can use next SQL request:Code: Select all
select * from actor where actor_id in ({Substring(ToString(Variable1), 1, Length(ToString(Variable1)) - 2)})
Code: Select all
select * from ServiceType where Title in ('''')
Code: Select all
{Substring(ToString(var1), 1, Length(ToString(var1)) - 2)}