[Qgis-user] Updating multiple parent/child records simultaneously

[Alexandre Neto]

Hi,

I have been looking for the same myself. I think I would be able to create
a "replicate relations" plugin but I am missing a step... this one:

https://gis.stackexchange.com/questions/353309/open-feature-form-in-multi-edit-mode-using-pyqgis

The idea would be to, for each selected feature, create an row in the
related table, then open them all with the multi editing form.

Alexandre Neto

On Wed, Oct 2, 2019 at 11:35 AM McDonaldR <McDonaldR at angus.gov.uk> wrote:

> Hi list,
>
>
>
> I’ve got a project set up in QGIS 3.4.x with a parent polygon layer and a
> child attribute layer.  Each site polygon represents a piece of land and
> can have multiple tasks associated with it (grass cutting, weeding,
> pruning, etc.).  Sites can be made up of multiple polygons.
>
>
>
> With relations set up in the project it is easy to select a polygon
> feature and update attributes.  It is easy to add or edit associated
> tasks.  See screenshots below.  With multiple site polygons selected I can
> use the “modify selected attributes simultaneously” to update information.
>
>
>
> I need to find a way to be able to select site polygons and add the same
> associated task to each one.  For example, select all site polygons that
> need grass cutting task associated with them, assign the task and maintain
> the parent child relationship.  It would be great if there was a way to do
> this through the form.
>
>
>
> One solution I have been toying with is using a SQL query to select the
> site polygons and insert into the associated tasks table a new record
> associated with each polygon.  The query works but I need a way to tie it
> into the form.  Anyone got any pointers?  Some python to call the SQL and
> get the selected feature IDs from QGIS?
>
>
>
> Thanks
>
>
>
> Ross
>
>
>
> Screenshot 1: https://nextcloud.mixedbredie.net/s/D7DFjs2PrcnEf7t
>
>
>
> Screenshot 2: https://nextcloud.mixedbredie.net/s/EBzeTopsBcZBSJc
>
>
>
>
>
>
>
>
>
>
>
> *Ross McDonald | *Geo-evangelist | Angus Council, Digital Enablement and
> IT | Angus House, Orchardbank Business Park, Sylvie Way, Forfar DD8 1AT*
> | t: 01307 49 22 39*
>
>
>
>
> This message is strictly confidential. If you have received this in error,
> please inform the sender and remove it from your system. If received in
> error you may not copy, print, forward or use it or any attachment in any
> way. This message is not capable of creating a legal contract or a binding
> representation and does not represent the views of Angus Council. Emails
> may be monitored for security and network management reasons. Messages
> containing inappropriate content may be intercepted. Angus Council does not
> accept any liability for any harm that may be caused to the recipient
> system or data on it by this message or any attachment.
> _______________________________________________
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200317/e889d567/attachment.html>