I need to figure out how I can do a big mass-update of the value of a userdefined number value on person.
Using plain SQL I would have done something like this:
update crm7.udpersonsmall set long05 = long05 + 1
But since this solution need to work in Online, where we can't run SQL queries, I need to figure out how to do it using CRMScript.
As a start, I'm trying to do an update using a reverse join, like this, but it's not working.
I also briefly looked at the NSImportAgent, but not sure if that is the way to go either.
Looping over every person and using NSPersonEntity to make the change would take too long, since I need to be able to update tens of thousands of persons.