What is the best way to clean up and delete useless / redundant History entries?
Hi community, I assume many of you use the item history for Parts, CAD or other ItemTypes. Dependent on how you configured the history, the history entries itself are more or less useful. I noticed that we get a lot of useless history entries, when users do mainly relationship edits. In this case we often have plain "update" entries without any comment. Some of these empty "update" entries are caused by Methods in the background. See also: link The history table can be one of the biggest in Innovator, so I wonder if we can do some cleanup to optimize the data quality? In our case I expect 20%-25% of the history entries to be redundant. I definitely don´t want to remove all "Update" related entries. But I only want to store the "last" entry of a major change operation. Just the ones that are around less than 30 seconds apart, were created by the same person and have no comment. Example: Is there any other answer than "SQL" (or AI ) to analyse which entries can be deleted? Is there anything else we need to consider? Thanks for any suggestions or second thoughts! AngelaHow to prevent/suppress that history entries are created automatically for AML update queries?
Hi community, does anyone know a way to prevent that Innovator creates a history entry when executing an AML update query? Let´s assume we have an ItemType with History enabled. These track property updates which is ok. I have a few custom Methods that do something. They write their own history entries with another custom Method. These history entries are more precise than the regular ones by Innovator. So I want to prevent hat Innovator add it´s own history entries, cause they just would spam the history. I would be happy to have a solution to suppress that Aras creates history entries for certain update AML queries on demand. Something like the "serverEvents=0" attribute, but for history entries. Does somebody know if there is a solution available? One solution is not to use AML, but SQL for update. But it´s not my preferred solution. Thanks for any hint! Angela
How to add History using a custom method?
I want to log in History when a specific "Action" is performed on a "Part" . I try to do this by adding to the "History" table. I do get a response that the record is added, However, I do not see a record in the database, neither visible in the History View. I try to do this by invoking "History Daemon" identity. How can i achieve this in Aras? <AML> <Item action='add' type='History'> <action>Special Action</action> <source_id>#######ITEM HISTORY CONTAINER ID#############/source_id> <comments>Attempted Special Action</comments> <item_id>#######ITEM ID##############</item_id> </Item> </AML>LifeCycle Get History Comment -> Can we retrieve the user input on runtime?
Hi Community, I have a short question regarding the 'Prompt History Comment' feature that we can use in LIfeCycles. When we choose "Get Comment = 1" for a LifeCycle Transition, the end user will be asked with a dialog to add some notes why the lifecycle was changed. This is for e.g. useful, when a LifeCycle was Cancelled and user can explain why they cancelled it. The comment than appears in the History of the item. When my LifeCycle is Cancelled, affected users will get informed by email. It would be helpful if the history comment would be included in the mails. Is it possible to pass the user input to an Email Message? Of course I could make a query for the new history entry, but I want to avoid query on the History, cause it´s quite performance consuming. Hope anyone has an idea! Thanks for any help! Angela
Track the fields/properties in Aras like History Container
Hello Experts, Is there any way in the Aras to check which property is modified while updating the Item? I have part item and while updating, i wanted to check which properties are modified likewise it is given in History page. E.g I have the properties in the Part as Name, Item Number, Description, Classification etc. User tried to update the Name and Description so i wanted to know that only these two properties are changed. If i enable the track history for these 2 properties then i can see the modified properties details in the History page. I want this information of properties on item type server events like, OnBeforeUpdate, OnAfterUpdate etc.
