[Qgis-user] About wfs update to multiple rows

[Jorge Infante]

Hi
I need to produce a wfs update to multiple rows, computing the value of
property using existing value (like property = property * 2).
Is it posible?
I'm preparing this xml, but, I need complete it:

<wfs:Update typeName="mylayer">
 <wfs:Property>
   <wfs:Name>myattribute</wfs:Name>
   <wfs:Value> </wfs:Value>  <---- I need put the computed value here
 </wfs:Property>
 <ogc:Filter>
   <ogc:And>
     <ogc:PropertyIsGreaterThan>
       <ogc:PropertyName>id</ogc:PropertyName>
       <ogc:Literal>9</ogc:Literal>
     </ogc:PropertyIsLessThan>
     <ogc:PropertyIsLessThan>
       <ogc:PropertyName>id</ogc:PropertyName>
       <ogc:Literal>19</ogc:Literal>
     </ogc:PropertyIsLessThan>
   </ogc:And>
 </ogc:Filter>
</wfs:Update>

I need to produce a sql like this:

update mylayer set myattribute = myattibute * 2 where id between 10 and 20;

Is it posible?

Thanks

jorge infante
rosario - santa fe - argentina
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190611/b3d35cf9/attachment.html>