WebGIS Discussions

[MiVoinea]

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!

export.zip ‏30 KB

[jan.neumann]

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

[MiVoinea]

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=...

[jan.neumann · Accepted solution]

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

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>

[MiVoinea]

Yes, that worked, thanks!