Opened 13 years ago

Last modified 13 years ago

#3670 new defect

OGC Filter FeatueId request and quotes

Reported by: assefa Owned by: assefa
Priority: normal Milestone: 6.0 release
Component: WFS Server Version: unspecified
Severity: normal Keywords:
Cc:

Description

When building the mapserver expressions based on OGC filters, we put usually quotes around values that seems to be of character types and do not put quote on number type values. The use can also specify the gml_myattributename_type 'Character'

This last specification is not currently used for FeatureId type OGC Filter quesries

Attachments (1)

bug_3670_5.6.x.patch (1.3 KB ) - added by assefa 13 years ago.
patch fr the 5.6.x branch

Download all attachments as: .zip

Change History (4)

by assefa, 13 years ago

Attachment: bug_3670_5.6.x.patch added

patch fr the 5.6.x branch

comment:1 by assefa, 13 years ago

Let me know if the patch works for you. Basically you should be able to define gml_attributeusedforfeatureid_type 'Character' and hav your quote generated.

If did not test the patch since I do not have a handy example.

comment:2 by hopfgartner, 13 years ago

Our query, that started it all was: http://192.168.0.13/gisclient-openlayer-dev/public/services/ows.php?PROJECT=melzo&MAP=DB_Topografico&SERVICE=WFS&VERSION=1.1.0&REQUEST=GETFEATURE&SRS=EPSG:32632&TYPENAME=a020102&FILTER=%3Cogc:Filter%20xmlns:ogc=%22http://www.opengis.net/ogc%22%3E%3Cogc:PropertyIsEqualTo%3E%3Cogc:PropertyName%3Eedifc_id%3C/ogc:PropertyName%3E%3Cogc:Literal%3E123%3C/ogc:Literal%3E%3C/ogc:PropertyIsEqualTo%3E%3C/ogc:Filter%3E

Trying to find where our problems were, we saw the issue with the feature id, even if this is not impacted by this query, which is handled in FLTGetBinaryComparisonSQLExpresssion. To make a long story short: How should I modify the above query in order to force the value to be evaluaded as a "Character"? Where should my "edifc_id_type" go?

comment:3 by assefa, 13 years ago

It is a layer level metadata. It should read "gml_edific_id_type" "Character"

Note: See TracTickets for help on using tickets.