Hexagon Geospatial
MENU

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
Occasional Contributor
Posts: 10
Registered: ‎10-05-2018

Re: Gazetteer example

I exported to mdb (to check if it's not an sql issue) and changed WFSGOrigPipe and DatabaseSpecialCharacters but it's the same, itstill requires to put wildcard * before string in search box.

 

On the same server USSampledata.mdb works with no problem and I can't see what is wrong.

I attached in the archive webconfig and mdb I use (without data, if you need I will put mdb with data).

 

Could you please help me?

Thanks!

Technical Evangelist
Posts: 978
Registered: ‎09-11-2015

Re: Gazetteer example

The search string template can be configured in Portal's web.config. Apologies for not telling about this capability sooner as it was hidden to me too. But it's documented:

https://hexagongeospatial.fluidtopics.net/reader/Ri9h_prdpLccXjehuNAyVQ/zMzPwSwU8P1PGLxThQ43vQ

 

If you just need to add second * symbol before the search term, you can use this setting:

<add
key="Intergraph.WebSolutions.Core.SDIPortal.WFSG.Gazetteer.FilterTemplate"
value="&lt;ogc:PropertyIsLike wildCard=&quot;*&quot; singleChar=&quot;?&quot; escapeChar=&quot;\&quot; xmlns:ogc=&quot;http://www.opengis.net/ogc&quot;&gt;&lt;ogc:PropertyName&gt;alternativeGeographicIdentifier&lt;/ogc:PropertyName&gt;&lt;ogc:Literal&gt;*{query}*&lt;/ogc:Literal&gt;&lt;/ogc:PropertyIsLike&gt;"
/>

 

Jan

Jan Neumann
Post Sales Engineer Web Applications
Hexagon Geospatial

Occasional Contributor
Posts: 10
Registered: ‎10-05-2018

Re: Gazetteer example

I didn't work. I put that in Portal's web.config (there was a simmilar line commented there) and now iitdid't give any result; in log I have only

<Filter xmlns="http://www.opengis.net/ogc">
<PropertyIsLike wildCard="*" singleChar="?" escapeChar="\">
<PropertyName>alternativeGeographicIdentifier</PropertyName>
<Literal>*andrei*</Literal>
</PropertyIsLike>
</Filter>

 

Whatever database I use (mdb or SQL, changing DatabaseSpecialCharacters) it has the same results, no line like

Getting database recordset feature=...

Highlighted
Technical Evangelist
Posts: 978
Registered: ‎09-11-2015

Re: Gazetteer example

Surely it doesn't work as the commented example was wrong. It uses alternativeGeographicIndentifier instead of the geographicIndentifier Smiley Frustrated

 

This fixed setting should work:

<add 
key="Intergraph.WebSolutions.Core.SDIPortal.WFSG.Gazetteer.FilterTemplate"
value="&lt;ogc:PropertyIsLike wildCard=&quot;*&quot; singleChar=&quot;?&quot; escapeChar=&quot;\&quot; xmlns:ogc=&quot;http://www.opengis.net/ogc&quot;&gt;&lt;ogc:PropertyName&gt;geographicIdentifier&lt;/ogc:PropertyName&gt;&lt;ogc:Literal&gt;*{query}*&lt;/ogc:Literal&gt;&lt;/ogc:PropertyIsLike&gt;" />

XML form is then like

<ogc:PropertyIsLike wildCard="*" singleChar="?" escapeChar="\" xmlns:ogc="http://www.opengis.net/ogc">
	<ogc:PropertyName>geographicIdentifier</ogc:PropertyName>
	<ogc:Literal>*{query}*</ogc:Literal>
</ogc:PropertyIsLike>
Jan Neumann
Post Sales Engineer Web Applications
Hexagon Geospatial

Occasional Contributor
Posts: 10
Registered: ‎10-05-2018

Re: Gazetteer example

Yes, that worked, thanks!

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