Update Sequence property to existing records

Offline Sathish Vor über 1 Jahr

After adding a new sequence property to an existing item type, how can i update the value for existing records in database?

It tried to update using server method

string nextSequence= inn.getNextSequence("newSequence");
Item editSelectionSet = inn.newItem("myItemtype", "edit");
editSelectionSet.setID(thisSelectionSet.getID()); //looping all records here to get current row id
editSelectionSet.setProperty("my_sequence", nextSequence);
editSelectionSet = editSelectionSet.apply();

Top Replies

Offline Eva DHR Vor über 1 Jahr +1

If your property is already defined as a Sequence Property you cannot update it - it is handled by Aras. In order for you to change its value, the property needs to be a string property and your code should…

Parents

0 Offline Eva DHR Vor über 1 Jahr

If your property is already defined as a Sequence Property you cannot update it - it is handled by Aras. In order for you to change its value, the property needs to be a string property and your code should work perfectly then
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Offline Eva DHR Vor über 1 Jahr

If your property is already defined as a Sequence Property you cannot update it - it is handled by Aras. In order for you to change its value, the property needs to be a string property and your code should work perfectly then
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 AngelaIp Vor über 1 Jahr in reply to Eva DHR

Good catch Eva, I guess this was the solution!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Update Sequence property to existing records

Top Replies

Legal

Connect With Us