[Qgis-user] Relation widget values

[Alessandro Pasotti]

On Fri, Mar 13, 2020 at 10:59 PM Nyall Dawson <nyall.dawson at gmail.com> wrote:
>
> On Sat, 14 Mar 2020 at 07:54, Régis Haubourg <regis.haubourg at gmail.com> wrote:
> >
> > Hi,
> > No workaround. QGIS makes relations on the tables that are loaded in QGIS. You will always need both tables.
>
> That's correct, but I believe in 3.12 Alessandro improved this so that
> the dependent tables are automatically loaded when the qlr itself is
> loaded.
>
> Nyall

Yes, have a look at https://github.com/qgis/QGIS/pull/32487 for
value-relation widgets,
and there is another following PR for relation-reference widget.

It's in QGIS 3.12


>
> > Régis
> >
> > Le ven. 13 mars 2020 à 21:21, Jean-Philippe Chenel <jp.chenel at live.ca> a écrit :
> >>
> >> Hi,
> >>
> >> I've a question regarding the Value Relation Widget under Layer Properties/Attributes Forms. Making the configuration work very well to bind a field to a list of values of another table in the project.
> >>
> >> When all is done, I make a qlr file to save all the layer definitions.
> >>
> >> The problem appears when I reload the qlr file without all the relational tables. The fields are bound, but the values aren’t displayed. To make this work, I need to add the relational tables to the project too.
> >>
> >> Does it have a workaround or an alternative to make it work without adding all the tables to the project? I saw in the qlr file that the connection to postgresql and all needed information are in the file to make it work.
> >>
> >> Database: postgresql 9.6
> >> QGIS version 3.10.3
> >> Layers and tables are in the database.
> >>
> >> With best regards,
> >> _______________________________________________
> >> Qgis-user mailing list
> >> Qgis-user at lists.osgeo.org
> >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >
> > _______________________________________________
> > Qgis-user mailing list
> > Qgis-user at lists.osgeo.org
> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user



-- 
Alessandro Pasotti
w3:   www.itopen.it