Dear list I have a service providing harmonized data. The service works, only the storedquery urn:ogc:def:query:OGC-WFS::GetFeatureById throws an error
I get the first record to find an ID https://inspire.informatievlaanderen.be/overdrachtdiensten/hy-n/wfs?VERSION=2.0.0&SERVICE=WFS&REQUEST=GetFeature&typeNames=hy-n%3AWatercourseLink&count=1 GetFeature/FeatureID works ok https://inspire.informatievlaanderen.be/overdrachtdiensten/hy-n/wfs?VERSION=2.0.0&SERVICE=WFS&REQUEST=GetFeature&typeNames=hy-n%3AWatercourseLink&FeatureID=vha_waterloopsegment_100000 The stored query throws an error: Could not find feature with specified id https://inspire.informatievlaanderen.be/overdrachtdiensten/hy-n/wfs?SERVICE=WFS&REQUEST=GetFeature&VERSION=2.0.0&storedquery_id=urn%3Aogc%3Adef%3Aquery%3AOGC-WFS%3A%3AGetFeatureById&outputformat=application%2Fgml%2Bxml%3B%20version%3D3.2&id=vha_waterloopsegment_100000&typename=hy-n%3AWatercourseLink I use Geoserver 2.15 Data is stored in sqlserver I use the AppSchema extension (And I paste the definition below) Is there something wrong in this definition. The storedquery works all right in my other services, that don't use the app schema extension. For example https://geoservices.beta.informatievlaanderen.be/overdrachtdiensten/Adressen/wfs?service=WFS&REQUEST=GetFeature&STOREDQUERY_ID=urn:ogc:def:query:OGC-WFS::GetFeatureById&ID=Adrespos.1000320856&typename=Adressen:Adrespos&outputformat=GML2 I examined the log files, but I couldn't find anyting more than "Could not find feature with specified id" (GEOTOOLS_DEVELOPER_LOGGING) Thanks Bart <targetTypes> <FeatureType> <schemaUri>http://inspire.ec.europa.eu/schemas/hy-n/4.0/HydroNetwork.xsd</schemaUri> </FeatureType> </targetTypes> <typeMappings> <FeatureTypeMapping> <sourceDataStore>dataStore</sourceDataStore> <sourceType>WatercourseLink</sourceType> <targetElement>hy-n:WatercourseLink</targetElement> <attributeMappings> <AttributeMapping> <targetAttribute>nns:beginLifespanVersion</targetAttribute> <sourceExpression> <OCQL>beginLifespanVersion</OCQL> </sourceExpression> </AttributeMapping> <AttributeMapping> <targetAttribute>nns:centrelineGeometry</targetAttribute> <idExpression> <OCQL>strConcat('centrelineGeometry.', getId())</OCQL> </idExpression> <sourceExpression> <OCQL>SHAPE</OCQL> </sourceExpression> </AttributeMapping> <AttributeMapping> <targetAttribute>nns:fictitious</targetAttribute> <sourceExpression> <OCQL>fictitious</OCQL> </sourceExpression> </AttributeMapping> <AttributeMapping> <targetAttribute>hy-n:flowDirection</targetAttribute> <ClientProperty> <name>xlink:href</name> <value>flowDirection_href</value> </ClientProperty> </AttributeMapping> <AttributeMapping> <targetAttribute>hy-n:WatercourseLink</targetAttribute> <idExpression> <OCQL>gml_id</OCQL> </idExpression> </AttributeMapping> <AttributeMapping> <targetAttribute>gml:identifier</targetAttribute> <sourceExpression> <OCQL>gml_identifier</OCQL> </sourceExpression> <ClientProperty> <name>codeSpace</name> <value>gml_codespace</value> </ClientProperty> </AttributeMapping> <AttributeMapping> <targetAttribute>nns:inNetwork</targetAttribute> <ClientProperty> <name>nilReason</name> <value>inNetwork</value> </ClientProperty> <ClientProperty> <name>xsi:nil</name> <value>if_then_else(isNull(inNetwork), Expression.NIL, 'true')</value> </ClientProperty> </AttributeMapping> <AttributeMapping> <targetAttribute>nns:inspireId/base:Identifier/base:localId</targetAttribute> <sourceExpression> <OCQL>inspireId_localId</OCQL> </sourceExpression> </AttributeMapping> <AttributeMapping> <targetAttribute>nns:inspireId/base:Identifier/base:namespace</targetAttribute> <sourceExpression> <OCQL>inspireId_namespace</OCQL> </sourceExpression> </AttributeMapping> <AttributeMapping> <targetAttribute>hy-n:length</targetAttribute> <sourceExpression> <OCQL>length</OCQL> </sourceExpression> <ClientProperty> <name>xsi:nil</name> <value>if_then_else(isNull(length), 'true', Expression.NIL)</value> </ClientProperty> <ClientProperty> <name>uom</name> <value>length_uom</value> </ClientProperty> </AttributeMapping> <AttributeMapping> <targetAttribute>nns:inspireId/base:Identifier/base:versionId</targetAttribute> <sourceExpression> <OCQL>inspireId_versionId</OCQL> </sourceExpression> </AttributeMapping> </attributeMappings> </FeatureTypeMapping> </typeMappings>
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users