topic Re: Editor Tracking & Related Table Inheritance? in Geodatabase Questions

Editor Tracking & Related Table Inheritance?

ZacharyHart — Fri, 01 Jul 2022 13:42:15 GMT

When editor tracking is enabled on both a parent and related child object, should it be the case that when editing the parent object/table that the updated editor tracking should be reflected in the related table?

Re: Editor Tracking & Related Table Inheritance?

jcarlson — Fri, 01 Jul 2022 13:47:40 GMT

Should it? I would say no. Let's say I had a layer of utility poles, and related layers of the things attached to these poles. If I make a minor update to one of the pole's attributes or correct its position, I do not want this action to overwrite the "last edited by" information in all the related features.

I want to know who last edited a specific transformer, so I need to be assured that this isn't showing me who last edited something else that happens to be related to the transformer.

Re: Editor Tracking & Related Table Inheritance?

ZacharyHart — Fri, 01 Jul 2022 13:50:14 GMT

This makes good sense, thank you!

Re: Editor Tracking & Related Table Inheritance?

jcarlson — Fri, 01 Jul 2022 13:54:06 GMT

I should say, though, that if you're interested in finding out the last-edited element anywhere in the chain of related items, you could do that with Arcade. I do use this for a particular dataset for complaints and investigations, where a manager may want to see what the most recent edit was for a given complaint. The expression can return something like "Most recent edit: Violations table, Jun 21, 2022 10:24 AM".

Re: Editor Tracking & Related Table Inheritance?

ZacharyHart — Fri, 01 Jul 2022 13:56:46 GMT

I'm intrigued if you are willing to share more.

Re: Editor Tracking & Related Table Inheritance?

jcarlson — Fri, 01 Jul 2022 14:02:48 GMT

Already posted about it! Just had to track down the link.

https://community.esri.com/t5/arcgis-online-blog/show-the-most-recent-edit-across-multiple-tables/ba-p/1136558

Re: Editor Tracking & Related Table Inheritance?

ZacharyHart — Fri, 01 Jul 2022 14:18:55 GMT

thanks so much! This is a great write-up!