What is the easiest way to see when/who made changes to a part method? I created a changelog for partopr table but I can’t figure out where I would view that from or how to get this since changes are done/tracked through ECOOprDtl which in turn updates the PartOprDtl table.
Use Data Directives Maintenance to create logging on specific tables.
I created one for the PartOpr table - but don’t know where you would view this change log - since you actually check the part out in Engineering Workbench (adding records to ECOOpr table which then in turn updates the PartOpr table) and I don’t see an option to view a change log in ECOOpr table -
Using BAQ I do notice both tables have a time stamp of some sort but don’t know how to convert into legible format.
You can also have a date field (textbox) added, then populate it with the time stamp you found in the BAQ.
If you want real time updates, you can create a bpm that will send an email you whenever an update is made.
In the BPM you can also query for the change log for the specific part number and send it as part of the email.
We use the ECO tables for that. Everyone who makes changes to methods uses their own ECO group, and this will show you when it got checked in, and what group checked it in (and thus who). The query below looks only and the list of materials that goes into that part, because we use it mostly to track down when imports don’t have the right BOM’s on them, but I think you could add ECOopr tables and be able to get those as well. There is a parameter to enter a part number to reduce the amount of record you receive.
PartECOHistory.baq (132.6 KB)
Is this a Data directive you created and where would you view the change log for ECO tables? I don’t see the option.
It’s just a query, the ECO tables already keep track of that for you. The PartOpr tables is the current ops, but the ECOOpr keeps track of what was on the part when it was checked back in.
After you have set up a Data Directive (and a change has been made to the table you put it on); you run the Change Log Report under System Setup/Security Maintenance.
Thanks - was not aware of that nice report.