Update minor_rev property is possible without applySQL

Hi,

I need to update the "minor_rev" property and I came across this post:

https://www.aras.com/community/f/development/3845/update-the-minor_rev-property-with-client-method-fails 

So basically if you put a value like "1" into "Default Value" in an ItemType, then you will be able to update the "minor_rev" property like:

item.setProperty("minor_rev", "2");

Hope it helps!

  • Hi Krepop,

    Thank you for taking up the topic! The post is pretty old, but I still update the minor rev with SQL till today! For example when user copy an item and the value shall be reset to "01".

    Unfortunately your tip didn´t work for me. I already had a "Default Value" specified . 

    Out of interest I made a quick test in Release 2023 and even there I wasn´t able to do a simple update of the minor_rev with AML. It doesn´t make any sense at all.

    Angela

  • Hi AngelaIp,

    Thanks for your help!

    I tested it further and you are right, it is still not possible, I thought it had to do with the "Manual" versioning but it seems it is not connected to that.

    I updated minor_rev with SQL and OnBeforeVersion, sorry for the confusion!

  • I also use "Manual" mode, not sure how situation is for "Automatic". Even at database level the property shows no difference to the others.

    I assume it´s a 25 year old core bug that survived all updates till today. I hope the mystery one day can be solved!

  • I agree! I have a Form where I can edit major/minor rev - the major gets checked for input and not being updated on wrong input, but - minor rev simply ignores any input.

  • I think minor_rev is rated as system property and cannot be changed. If you try to change created_on, state or any other of these properties, the query would also ignore these requests.

    This is some core Innovator behavior and it of course makes sense for important stuff like the ids.

    My theory right now: In the past major_rev was also a hard restricted property, but then Aras changed it due to some requirement. So this is why the major_rev is editable today. But they didn´t change the minor_rev, cause Aras doesn´t use the minor_rev. The developers just did what they were told and that´s what we see today Slight smile