07-16-2019 04:12 AM
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
07-17-2019 12:17 AM
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:
Regards,
Jan
07-17-2019 01:44 AM
Hi Jan,
In the meanwhile i saw that issue and i change the target to a column with first letter capitalized.
Thanks,
Rui