Ok - that explains it. It is quite confusing that QGIS uses a different internal ID than the primary key column of the database. Is there a technical reason for this behaviour?
Andreas On Thu, 8 Jul 2021 at 11:43, Alexandre Neto <[email protected]> wrote: > As far as I remember @atlas_featureid has always returned the same as the > $id in the attributes table, which is kind of the internal row number. > > Alex > > A quinta, 8/07/2021, 10:35, Andreas Neumann <[email protected]> escreveu: > >> HI Jürgen, >> >> Yes - I provided the primary key column >> >> Here is my data source string: >> >> service='edit' authcfg=sogis00 key='t_id' srid=2056 type=Polygon >> checkPrimaryKeyUnicity='1' >> table="alw_strukturverbesserungen"."projekt_aggregiert_v" >> (geometrie_convex_hull) sql=geometrie_bbox IS NOT NULL >> >> @atlas_featureid returns something like an internal "row number" or >> similar, but not the column "t_id" as defined in the data source string. >> >> Andreas >> >> On Thu, 8 Jul 2021 at 10:42, Jürgen E. Fischer <[email protected]> wrote: >> >>> Hi Andreas, >>> >>> On Thu, 08. Jul 2021 at 10:30:08 +0200, Andreas Neumann wrote: >>> > attribute(@atlas_feature,'pkey_name'), but it is a little more >>> complicated >>> > than @atlas_featureid - and I'm pretty sure that @atlas_featureid was >>> using >>> > the pkey column in th past? >>> > >>> > My data source for the atlas coverage layer is a Postgis View. >>> >>> It's probably not using the column you expect for the feature id. Did >>> you >>> specify the key column when adding the view? >>> >>> >>> Jürgen >>> >>> -- >>> Jürgen E. Fischer norBIT GmbH Tel. >>> +49-4931-918175-31 >>> Dipl.-Inf. (FH) Rheinstraße 13 Fax. >>> +49-4931-918175-50 >>> Software Engineer D-26506 Norden >>> https://www.norbit.de >>> QGIS release manager (PSC) Germany IRC: jef on >>> Libera|OFTC >>> _______________________________________________ >>> QGIS-Developer mailing list >>> [email protected] >>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer >>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer >>> >> >> >> -- >> >> -- >> Andreas Neumann >> QGIS.ORG board member (treasurer) >> _______________________________________________ >> QGIS-Developer mailing list >> [email protected] >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer >> > -- -- Andreas Neumann QGIS.ORG board member (treasurer)
_______________________________________________ QGIS-Developer mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
