What does the Update field mean in the Customer Updates table?

[JennyHu]

Hi there,

Does anyone know what the Updates field mean in the Customer Update (sys_update_xml) table?

I am reviewing the customer updates in my local update set, and I see this number ranges from 0 and up.

What does it mean if the number is 0 in the Updates field?

Thanks,

Jenny

[Jaspal Singh]

Hi Jenny,

It describes the number of times the record has been updated. For instance, a dictionary override is done for incident in 2 steps

1. over-ride read only & then save

2. over-ride default & then save

So save is done twice hence the update would show up 2.

Link Customer updates table   would help you understand it better.

[Jaspal Singh]

Hi Jenny,

If you got what was expected you can mark this thread as correct & close it so that it does not appear in unanswered list.

[JennyHu]

Hi Jaspal,

Thanks for your reply and the link.   It is helpful.   I still have a question about when the number in the Update field is 0, what does it mean?   Does it mean that the record was newly created so there are no "updates"?

Also, I was cross referencing the Update (sys_mod_count) number in Customer Update against the Update Versions (sys_update_version) for a record producer.   The Update number shows 10, however there are 17 versions for that record.   Does that mean that there are 10 updates captured in the current update set, and there are 7 updates that are captured in other update set(s)?

Thanks,

Jenny