Hexagon Geospatial
MENU

GeoMedia Smart Client

GeoMedia Smart Client community discussion board is where you can create, contribute and share information and knowledge in regards to configuring as well as working with GeoMedia Smart Client. Find your answers, share your knowledge and help build a strong GeoMedia Smart Client community.
Showing results for 
Search instead for 
Do you mean 
Reply
Contributor
Posts: 70
Registered: ‎11-11-2015

GMSC Queries using IN()

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

Staff
Posts: 1,036
Registered: ‎10-18-2015

Re: GMSC Queries using IN()

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

Stefano Turcato
Presale Engineer
Hexagon Geospatial
Do you need immediate support?
If you encounter a critical issue and need immediate assistance please submit a Service Request through our Support Portal.