Updating custom fields on superseded Items

Question

Hello, 
 We have a program which we run to update Export control codes on our parts, this is to obviously restrict access to comply with Export control regulations and as such is very important. 
 The issue we are having is that we can update the active revision of the part but we need this to cover all revisions as we would not want someone to access these if they are controlled items. 
 how can we update these custom fields on older revisions and superseded items?

Christopher Gillis · Answer

Hi Rikky, 
 The simplest way to accomplish this would be to use an onBeforeAdd/ onBeforeUpdate event that checks propagates the value of this Export Control Code to all previous generations of the Part. We typically don't recommend using direct SQL as it bypasses the Aras permission model, but in this case, I think it might be your best option as a SQL update won't run any other versioning logic. You can find all generations of a Part by searching on the config_id property which is common among all generations of an item. 
 Chris 
 Christopher Gillis 
 Aras Labs Software Engineer