Bug report #21522

Realtion - Problem with ogc_fid field in the parent table

Added by Roberto Marzocchi about 5 years ago. Updated about 5 years ago.

Status:Closed
Priority:Normal
Assignee:Matthias Kuhn
Category:Relations
Affected QGIS version:3.4.5 Regression?:No
Operating System:Ubuntu Easy fix?:No
Pull Request or Patch supplied:No Resolution:invalid
Crashes QGIS or corrupts data:Yes Copied to github as #:29338

Description

I create a relation using the "id" field in the parent table and "id_grupposegnale" in the child table
Definition of relation

Nevertheless the relation do not use the "id" field but another field called "ogc_fid"

Parent fields:!parent_fields.png!

Child field: Child field

relation_definition.png - Definition of relation (44.6 KB) Roberto Marzocchi, 2019-03-08 11:55 AM

parent_fields.png - Parent fields (48.8 KB) Roberto Marzocchi, 2019-03-08 11:55 AM

child_filed.png - Child field (6.3 KB) Roberto Marzocchi, 2019-03-08 11:55 AM

segnali_stradali.zip (2.77 MB) Roberto Marzocchi, 2019-03-08 12:16 PM

History

#1 Updated by Giovanni Manghi about 5 years ago

  • Status changed from Open to Feedback

Please attach a sample project with data.

#2 Updated by Roberto Marzocchi about 5 years ago

Attached the QGIS project with problem

#3 Updated by Giovanni Manghi about 5 years ago

  • Resolution set to invalid
  • Status changed from Feedback to Closed

The relation is invalid,
in "id_grupposegnale" of the child layer you have

COALESCE

in the relation reference widget.

Also available in: Atom PDF