Plugin icon

Select by relationship

Plugin ID: 1222

The plugin allows to select records through tables based on relationships one-to-one or one-to-many specified inside a QGIS project.

(36) votes 
 Download latest

The plugin allows to select records through tables based on relationships one-to-one or one-to-many specified inside a QGIS project.
The plugin button will appear inside QGIS database menu. Anything in 3 steps:
1.Charge in a QGIS project your layers;
2.Set up the relationships between your layers inside the QGIS project properties;
3.Click on selectFromRelations button (or run its from QGIS toolbar Database->Select From Relation -> Allow selections by relationship.

Now you can select records between many related tables.
You can see an example in this videotutorial by Salvatore Fiandaca: link
The plugin started by an original thread posted by Salvatore Fiandaca and developed by Andrea Borruso and Salvatore Larosa: Original thread
A first post by Andrea Borruso: link
The original python macro by Salvatore Larosa: link
A videotutorial by Salvatore Fiandaca where it's showed the use of python macro by Salvatore Larosa: link
An other videotutorial by Salvatore Fiandaca for testing the macro python code embedded inside selectFromRelations plugin: link

Version QGIS >= QGIS <= Date
0.3.3 - 3.16.0 3.99.0 5669 pyarchinit Feb 26, 2022, 10:15 AM UTC
0.3.2 3.0.0 3.99.0 2769 pyarchinit Oct 30, 2019, 10:50 AM UTC
0.3.1 3.0.0 3.99.0 298 pyarchinit Oct 26, 2019, 08:47 AM UTC
0.3.0 3.0.0 3.99.0 2724 pyarchinit May 17, 2018, 10:17 AM UTC
0.2.1 2.0.0 2.99.0 2486 pyarchinit May 1, 2017, 06:45 PM UTC
0.2 2.0.0 2.99.0 802 pyarchinit Apr 29, 2017, 09:01 AM UTC
0.1 2.0.0 2.99.0 627 pyarchinit Apr 20, 2017, 03:48 PM UTC

QGIS sustaining members

Flagship membership


Flagship membership


Large membership


Large membership


Large membership


Large membership


Large membership


Large membership


Large membership