WebGIS Discussions

[RRIBEIRO]

How can we force a wfs-g service to use uppercase in queries?

The database field we are searching for is in uppercase, but when we see the service log from the request made the field appears capitalized

rol-log.txt debug from service:

2019-07-16 10:20:11,047 [8] DEBUG Intergraph.GeoMedia.Web.SDI.Gazetteer.Pipes.WFSGOriginatingPipe.Common.NameMappingManager [(null)] - There was one for specified connection key. Returning it. (connection_key=xxx/xxx@SIGMAT,xxx@SIGMAT,OracleORW.GDatabase)
2019-07-16 10:20:11,047 [8] DEBUG Intergraph.GeoMedia.Web.SDI.Gazetteer.Pipes.WFSGOriginatingPipe.Common.DataAccessManager [(null)] - Getting database recordset feature='GIA.VCEIXOSVIA' sqlfilter=' ( ( ( ARRUAMENTO ) LIKE ( '%Manuel%' ) ESCAPE '\' ) ) '.

Web.config from Geospatial Portal:

<!-- Regular expression that qualifies words passed into gazeteer not to be capitalized. -->
<!-- <add key="Intergraph.WebSolutions.Core.SDIPortal.WFSG.Gazetteer.NamesExcludedFromCapitalization" value="^\W$" /> -->

Regards,

Rui Ribeiro

[jan.neumann]

Hi Rui,

The WFS-G will capitalize only the first letter. For an Oracle, you need to accomodate a work-around for the case sensitivity, similar to Colin explained in this topic:

https://community.hexagongeospatial.com/t5/WebGIS/Not-able-to-configure-WFS-G-with-oracle-and-postgi...

Regards,

Jan

[RRIBEIRO]

Hi Jan,

In the meanwhile i saw that issue and i change the target to a column with first letter capitalized.

Thanks,

Rui