Bug report #12165

Join the same table multiple times

Added by Andreas Neumann over 5 years ago. Updated over 5 years ago.

Status:Closed
Priority:Normal
Assignee:Martin Dobias
Category:Attribute table
Affected QGIS version:2.6.0 Regression?:No
Operating System:All Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:20358

Description

Currently, there is a limitation that a table can only be joined once. I wanted to join the same table multiple times - however, only the first join worked. All the other joined fields appear empty.

My use case:

table traffic_sign_posts (can have up to 4 different traffic signs) - has, amongst others, the following integer columns:
- sign1
- sign2
- sign3
- sign4

table traffic_signs - has the following columns:
- code (link to sign1 to sign4)
- name
- svg_symbol
- symbol_size
- symbol_offset

Now I wanted to join table "traffic_signs" 4 times to the table "traffic_sign_posts", joined with columns "sign1" to "sign4".

Associated revisions

Revision 68f94647
Added by Martin Dobias over 5 years ago

Fix #12165 - table can't be joined multiple times

History

#1 Updated by Martin Dobias over 5 years ago

  • Status changed from Open to Closed

Also available in: Atom PDF