[Qgis-user] Relation widget values

[Jean-Philippe Chenel]

Thank you very much, this Monday I’ll try the version 3.12. 

>> Le 13 mars 2020 à 18:16, Alessandro Pasotti <apasotti at gmail.com> a écrit :
> 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
> _______________________________________________
> 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