10-29-2018 05:56 AM
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!
10-30-2018 03:04 AM
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="<ogc:PropertyIsLike wildCard="*" singleChar="?" escapeChar="\" xmlns:ogc="http://www.opengis.net/ogc"><ogc:PropertyName>alternativeGeographicIdentifier</ogc:PropertyName><ogc:Literal>*{query}*</ogc:Literal></ogc:PropertyIsLike>" />
Jan
10-30-2018 04:36 AM
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=...
10-30-2018 06:08 AM
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="<ogc:PropertyIsLike wildCard="*" singleChar="?" escapeChar="\" xmlns:ogc="http://www.opengis.net/ogc"><ogc:PropertyName>geographicIdentifier</ogc:PropertyName><ogc:Literal>*{query}*</ogc:Literal></ogc:PropertyIsLike>" />
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>
10-30-2018 07:15 AM
Yes, that worked, thanks!