[Qgis-developer] Visualisation of relations

[Neumann, Andreas]

Hi Patrick, 

Matthias Kuhn, the one who knows about this the best, is currently out
of office / on holidays. I think he is back next week. 

I would probably wait for his review. 

Thanks and greetings, 

Andreas 

On 2016-10-12 09:48, Patrick Valsecchi wrote:

> No answer. I think I'll move forward with my proposal.
> 
> Thanks. 
> 
> On Fri, Oct 7, 2016 at 9:27 AM, Patrick Valsecchi <patrick.valsecchi at camptocamp.com> wrote:
> 
>> Hi,
>> 
>> I'm tasked with making QGIS a bit more usable with complex database schemas having a lot of relations (up to hundreds of linked tables). The INSPIRE people were a bit too inspired when creating their data schemas and now we have to try to make QGIS able to cope with that.
>> 
>> My concerns with the current situation (as of QGIS master) are:
>> 
>> * We can specify the relations between the layers at the project level (it's now easier with the auto-discover feature for PostGIS and Spatialite). But those are only showing in the QgsAttributeForm for the 1-N side (the side that doesn't have the foreign key). Why not on the N-1 side?
>> * For showing the N-1 side in the QgsAttributeForm, one can define a Join in the layer's properties, but I don't see the point of having to define it here as well when we have already the relations info at the project level. I see a use for special joins, but for relations, I don't see why we have to define it twice. And the way it's displayed is not allowing to create joins or edit the joined fields.
>> * I let you imagine the look of the feature attribute form when there are hundreds of directly and indirectly linked tabled. This is just not usable if we display all of them directly like that. Just look at the attached screen shot that shows what happens by default with only 3 tables. It's already a mess.
>> 
>> Now, what I propose is: 
>> 
>> * Not expand the relation widget (QgsCollapsibleGroupBox) by default and build it's content only when it is expanded the first time (think of what would happen when you have loops in the schema).
>> * Show N-1 relations as well, in a collapsed by default QgsCollapsibleGroupBox, including a way to add a new linked entry, remove the link (put the FK to NULL) and delete it.
>> * Add a button to open a related feature in a new window.
>> 
>> What do you guys think? 
>> 
>> Thanks.
> 
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer

  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20161012/b99ad99c/attachment-0001.html>