Hi, You can add the field a second time with "as ID" in SQL and then select this one to be the identifier.
Hope this helps. Envoyé à partir d’Outlook<http://aka.ms/weboutlook> ________________________________ De : mark <mc.pr...@gmail.com> Envoyé : 15 septembre 2023 06:29 À : geoserver-users@lists.sourceforge.net <geoserver-users@lists.sourceforge.net> Objet : Re: [Geoserver-users] Keep identifier field visible with a SQL View Layer Op 15-09-2023 om 10:41 schreef Alexandre Gacon: > Hello, > > Is there a way with a SQL View layer to keep the field marked as > 'identifier' in the attributes of the layer, in order to get it when > requesting the layer with WFS? For the moment we duplicate the field in > the view. Do you have the "expose primary keys" flag set on the datastore? I would think that should take care of that. -M _______________________________________________ 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: https://can01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.ianturton.com%2Ftalks%2Ffoss4g.html%23%2F&data=05%7C01%7C%7Cfa80cec740a048632bf708dbb5d6c484%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638303706247635917%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=TuSQlhgxJJNBaLkfFsC%2BcblqWCtq5DgEkikUDwTz2f4%3D&reserved=0<http://www.ianturton.com/talks/foss4g.html#/> - The GeoServer user list posting guidelines: https://can01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgeoserver.org%2Fcomm%2Fuserlist-guidelines.html&data=05%7C01%7C%7Cfa80cec740a048632bf708dbb5d6c484%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638303706247635917%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=M%2BvSiSb3YHM4er6gKXr5ZH4csXR2QMtuJ7nM22G6J7o%3D&reserved=0<http://geoserver.org/comm/userlist-guidelines.html> If you want to request a feature or an improvement, also see this: https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fgeoserver%2Fgeoserver%2Fwiki%2FSuccessfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer&data=05%7C01%7C%7Cfa80cec740a048632bf708dbb5d6c484%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638303706247635917%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=%2BJ3Tbr%2FQ9yuVVfllySHhwbVOg0bbkG8IbrGdajFZUnw%3D&reserved=0<https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer> Geoserver-users@lists.sourceforge.net https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.sourceforge.net%2Flists%2Flistinfo%2Fgeoserver-users&data=05%7C01%7C%7Cfa80cec740a048632bf708dbb5d6c484%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638303706247635917%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=OpFXp8%2BD0wGPp0qdc9HokyqSBF%2BU%2FeeK7stSr9CAGek%3D&reserved=0<https://lists.sourceforge.net/lists/listinfo/geoserver-users>
_______________________________________________ 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