GMSC Discussions

[fdriessen]

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

[sturcato]

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