Details

    • Type: Bug Bug
    • Status: Closed Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 1.6.5, 1.7.0
    • Fix Version/s: None
    • Component/s: PostGIS
    • Labels:
      None
    • Environment:
      suse sles 10
    • Number of attachments :
      0

      Description

      sending the filter-condition

      <ogc:Filter>
      <And>
      <ogc:PropertyIsLike wildCard='*' singleChar='.' escape='!'>
      <ogc:PropertyName>ud_id</ogc:PropertyName>
      <ogc:Literal>*888888888888</ogc:Literal>
      </ogc:PropertyIsLike>
      <ogc:PropertyIsEqualTo>
      <ogc:PropertyName>objekttyp_id</ogc:PropertyName><ogc:Literal>2</ogc:Literal>
      </ogc:PropertyIsEqualTo>
      </And>
      </ogc:Filter>

      via get-parameter to geoserver versions 1.6.5 and 1.7.0.
      Both versions build the sql statement:

      28 Okt 08:18:00 DEBUG [data.jdbc] - About to execute query:
      SELECT "object_id", "ud_id", "meldevertreter_id", "objekttyp_id", "bemerkung", "flaeche", "datum",
      encode(asBinary(force_2d("the_geom"),'XDR'),'base64'), "objekttyp_name" FROM "gis"."f_lw_digi_flaechen"
      WHERE ( ( "ud_id" LIKE '%999999999999' ) AND 'objekttyp_id' = '1') LIMIT 1000000

      The attribute-name objekttype_id is single quoted but has to be double quoted.

        Activity

        Hide
        Chris Holmes added a comment -

        This is probably no longer relevant with postgis-ng, if you confirm then close.

        Show
        Chris Holmes added a comment - This is probably no longer relevant with postgis-ng, if you confirm then close.
        Hide
        Andrea Aime added a comment -

        Tried a very similar one:

        <wfs:GetFeature service="WFS" version="1.0.0"
          outputFormat="GML2"
          xmlns:tiger="http://www.census.gov/tiger"
          xmlns:wfs="http://www.opengis.net/wfs"
          xmlns:ogc="http://www.opengis.net/ogc"
          xmlns:gml="http://www.opengis.net/gml"
          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
          xsi:schemaLocation="http://www.opengis.net/wfs
                              http://schemas.opengis.net/wfs/1.0.0/WFS-basic.xsd">
          <wfs:Query typeName="tiger:pgstates">
            <ogc:PropertyName>tiger:state_name</ogc:PropertyName>
            <ogc:PropertyName>tiger:persons</ogc:PropertyName>
            <ogc:Filter>
               <And>
        <ogc:PropertyIsLike wildCard='*' singleChar='.' escape='!'>
        <ogc:PropertyName>state_name</ogc:PropertyName>
        <ogc:Literal>M*</ogc:Literal>
        </ogc:PropertyIsLike>
        <ogc:PropertyIsEqualTo>
        <ogc:PropertyName>state_fips</ogc:PropertyName><ogc:Literal>30</ogc:Literal>
        </ogc:PropertyIsEqualTo>
        </And>
        </ogc:Filter>
          </wfs:Query>
        </wfs:GetFeature>
        

        against a "states" layer imported in PostGIS, no problems

        Show
        Andrea Aime added a comment - Tried a very similar one: <wfs:GetFeature service= "WFS" version= "1.0.0" outputFormat= "GML2" xmlns:tiger = "http://www.census.gov/tiger" xmlns:wfs = "http://www.opengis.net/wfs" xmlns:ogc = "http://www.opengis.net/ogc" xmlns:gml = "http://www.opengis.net/gml" xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.0.0/WFS-basic.xsd"> <wfs:Query typeName= "tiger:pgstates" > <ogc:PropertyName> tiger:state_name </ogc:PropertyName> <ogc:PropertyName> tiger:persons </ogc:PropertyName> <ogc:Filter> <And> <ogc:PropertyIsLike wildCard='*' singleChar='.' escape='!'> <ogc:PropertyName> state_name </ogc:PropertyName> <ogc:Literal> M* </ogc:Literal> </ogc:PropertyIsLike> <ogc:PropertyIsEqualTo> <ogc:PropertyName> state_fips </ogc:PropertyName> <ogc:Literal> 30 </ogc:Literal> </ogc:PropertyIsEqualTo> </And> </ogc:Filter> </wfs:Query> </wfs:GetFeature> against a "states" layer imported in PostGIS, no problems

          People

          • Assignee:
            Andrea Aime
            Reporter:
            Uli Rothstein
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: