Changing Object IDs

You should only change the object IDs belonging to references. You can do this, for example, when a salesperson has left the organisation and to assign all the customers s/he had assigned to him/her to another salesperson.

To change an object ID, use two queries. The first query outputs the instances of the class containing the current reference — for example, Salesperson — and the second outputs the instances that are referencing that instance — for example, Customers.

For example, to change the salesperson for all customers:

1. Highlight the new salesperson in the query results table. This is a query based on the SalesPerson class that outputs all salespeople. Then, right click.
2. Greentree Desktop prompts you to enter a write access password. This password changes daily. Contact your Greentree consultant for the password.
3. Right click the salesperson and select Copy to Clipboard as OID
4. Run the customer query (outputs customers using the Customer class). In the results table, right-click and select Select All to include all customers in the process (you must enter the password first). Then right click again and select Change Properties. In this example, find the OID to change, which is the mySalesperson:name:
5. Right-click in the Value section and select Paste. This pastes the OID of the salesperson into the section:
6. Click Change to run the update.