Hi,
is it possible to create a Dataobject with an "IN" SQL query?
I have no problem with:
select * from table where serialnumber = '%VARIABLE%' -> VARIABLE is A111 or B222 or C333
select * from table where serialnumber IN ('A111','B222','C333') -> also delivers the correct result
but when I try
select * from table where serialnumber IN %VARIABLE% -> VARIABLE is ('A111','B222','C333')
or
select * from table where serialnumber IN ('%VARIABLE%') -> VARIABLE is A111','B222','C333
I get no error but also no results
But this query works:
select * from table where serialnumber IN ('%VARIABLE%') -> VARIABLE is A111 or B222 or C333
so the problem seems to be the comma or the quote in the variable.
Any ideas if this should work?
Or is there another way to create a dynamic SQL query and use this in the dataobject?
Thanks and best regards,
Markus