11-04-2016 04:03 AM
hi,
our customer wants to be able to search for multiple strings, using one field in an attribute-query in GMSC.
is it possible to pass multiple values from the input field to the SQL-IN()-query?
i tried separating the strings with komma, unfortunately this does not work:
input: 'string1,string2,string3'
SQL: select .... where attribute IN ({ENTITY.INPUT})
is there a special function or workaround?
thanks!
Franz
11-04-2016 06:00 AM
Hi Franz,
it might be similar to this old post. If you don't have access to that forum, the idea behind is to make input fields not mandatory. The query was:
SELECT *
FROM BUILDINGEXTENSION
WHERE
Comments = coalesce(Nullif({ENTITY.FirstInput} , ''),Comments) AND
Editor = coalesce(Nullif({ENTITY.SecondInput} , ''),Editor)
You should be able to adapt it to the usage of just one column.
HTH,
Stefano