we try to update a single attribute of a number of objects using:
update Action set transferred = 1 where objectsInCharge.nodePath = '/(MA)ENTRYLEVEL-1'
it returns:
Query Execution Error
=====================
null
in the docs it is written to use something like:
UPDATE Country SET population = population * 11 / 10 WHERE c.population < :p
trying to use then
update Action set transferred = 1 where a.objectsInCharge.nodePath = '/(MA)ENTRYLEVEL-1'
ends up with
Query Execution Error
=====================
Unexpected query token 'a'
update Action set transferred = 1 where ==> a <== .objectsInCharge.nodePath = '/(MA)ENTRYLEVEL-1'
the normal query has for sure a number of results
select a from Action a where a.objectsInCharge.nodePath = '/(MA)ENTRYLEVEL-1'