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.valsec...@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@lists.osgeo.org > List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
_______________________________________________ Qgis-developer mailing list Qgis-developer@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer