Forum Discussion

Ideator I

7 years ago

Solved

aras_x003A_uniqueness_helper

I have a noticed the property 'aras_x003A_uniqueness_helper' on previous revisions of an item, what is this property used for?

christopher_gillis
7 years ago
Hello,

Angela did a good job of summarizing what this property is used for, but I'll try to rephrase it. When a versionable ItemType has some number of unique properties set on it, this uniqueness_helper is used to differentiate two versions of the same item that may have the same combination of values for the unique properties. As stated previously, this is a system property that is automatically set and can be ignored for all practical purposes.

Chris

Christopher Gillis

Aras Labs Software Engineer

7 Replies

AngelaIp
Ideator I
7 years ago
I remember that I have seen this one before, but I cannot remember in which context. Were do you see this property? In the database? In the client?
- Meismart
  Ideator I
  7 years ago
  I can query this property in SQL and AML using the Nash tool. I would like to know what it is used for behind the scenes. It seems to be a duplicate of the item id.
  - AngelaIp
    Ideator I
    7 years ago
    The uniqueness property is used on ItemTypes which are versionable, like Part, Document, etc. . Non versionable ItemTypes like User will not have this property.
    
    The property itself will be used as soon as you create a new revision of an item. The latest version of an Item will not have this property, while in the previous revisions the uniquness_helper is identical to the item id.
    
    It´s a system property, automatically set on database level. I don´t know the exact purpose, but it´s propably used to keep data consistent when using revisioning. You shouldn´t have to take care for this one.