Hi On Wed, Mar 20, 2013 at 9:47 AM, Andreas Neumann <a.neum...@carto.net> wrote: > Hi again, > > I wanted to add that the proposal also includes managing relations > (adding/removing relations) by picking one or more feature geometries in > the map or one or more records in a related table, once the relations > are defined in the relation manager and the widgets are defined accordingly. >
Hopefully it also covers implementation of tests too! :-) Regards Tim > Thanks, > Andreas > > Am 20.03.2013 08:32, schrieb Andreas Neumann: >> Hi all, >> >> The Swiss QGIS user community is increasingly building application >> modules around QGIS. Most of these modules require database relations - >> not only 1:1, but also 1:n and n:m relations. Currently, only 1:1 >> relations are supported (with some limitations) in QGIS through the >> table joins. >> >> Since many upcoming QGIS applications will require also 1:n and n:m >> relations we want to make database relations a core feature in QGIS. >> >> Matthias Kuhn from Switzerland already started work on this and will >> continue to work on it. Some swiss communities started funding this and >> other efforts in QGIS - now we are looking for some additional funding >> and are also approaching the international QGIS community for financial >> support. >> >> Matthias and Denis Rouzaud (both from Switzerland) already worked on the >> following forms and database improvements: >> >> * drag and drop forms designer - allows to easily re-order form widgets >> and group them in tabs and groups >> * combining forms and tables into a single window (dual view) >> * Allow to step through all records and forms one by one >> * Filters/Selections apply on both forms and table >> * database relations manager allows to set foreign key database >> relations (regardless of the provider - you can join f.e. a >> Postgis-table with a SQL-server table) >> >> The next steps would be the nested forms where one can embed one child >> form in another master form and the records are filled into the child >> form automatically based on the relation defined in the relations manager. >> >> We are looking for funding of CHF 13'000, approx. 10'500 € or 13'700 US$ >> to complete this work for the nested forms. >> >> If you have an interest in database relations and more complex forms >> please consider to support this important QGIS feature that will in the >> future allow to build more complex tools and applications with QGIS and >> databases. >> >> If you are interested, please contact me and I can forward you the more >> detailed specification of what we plan with the nested forms. >> >> Thank you, >> Andreas >> _______________________________________________ >> Qgis-developer mailing list >> Qgis-developer@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/qgis-developer >> > > _______________________________________________ > Qgis-user mailing list > qgis-u...@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/qgis-user -- Tim Sutton - QGIS Project Steering Committee Member (Release Manager) ============================================== Please do not email me off-list with technical support questions. Using the lists will gain more exposure for your issues and the knowledge surrounding your issue will be shared with all. Visit http://linfiniti.com to find out about: * QGIS programming and support services * Mapserver and PostGIS based hosting plans * FOSS Consulting Services Skype: timlinux Irc: timlinux on #qgis at freenode.net ============================================== _______________________________________________ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer