Hexagon Geospatial
MENU

Support WebGIS

Need a push in the right direction when configuring WebMap, Portal or SDI services? Looking for hints and tips, or just looking for Ideas and information? The WebGIS discussion board is where you start those discussions, connect and share information.
Showing results for 
Search instead for 
Do you mean 
Reply
Frequent Contributor
Posts: 123
Registered: ‎02-17-2016

WFS-G wildcard search

Hi - We have setup a WFS-G that is querying a field with values such as 

 

SR27 - SIGNALLING ROOM BUILDING WESTENHANGER

SR24 - SIGNALLING ROOM BUILDING LENHAM

SR26 - SIGNALLING ROOM BUILDING ASHFORD EAST

 

We would like to be able to search for 'Lenham', so have tried %Lenham but this does not work. The text is passed literally as LIKE ( '%lenham%' ) and no matches. The searches are setup to be case insensitive.

 

Is there a way to allow wildcards at the front of a search term on the WFS-G?

 

Thanks

 

Regular Contributor
Posts: 187
Registered: ‎10-26-2015

Re: WFS-G wildcard search

This issue is caused by the Portal web.config parameter Intergraph.WebSolutions.Core.SDIPortal.WFSG.Gazetteer.NamesExcludedFromCapitalization. It is not capitlising the letter entered in the search string '%lenham' and as the data is stored in Oracle, the LIKE query returns no matches. The user must type '%Lenham' to find a matching string.

 

Is there anyway to configure the NamesExcludedFromCapitalization parameter to either pass the search string entered to be lower or upper case?

Do you need immediate support?
If you encounter a critical issue and need immediate assistance please submit a Service Request through our Support Portal.