Select to view content in your preferred language

Python or SQL for 'Version Changes'?

1445
10
Jump to solution
11-30-2023 02:58 PM
Labels (3)
FredSpataro
Frequent Contributor

Hi All, 

There's an ArcPro tool called 'Version Changes' on the Versioning ribbon (see picture below).  Is there a python/gp tool or SQL template to achieve the same thing?  

We need to implement some automated QA/QC and auditing tasks.  It would be 'waaaayyyy' better if we could grab this info without asking the user to press the button. 

 

Thanks

FredSpataro_0-1701384984312.png

 

0 Kudos
10 Replies
FredSpataro
Frequent Contributor

@Bud yeah, the SQL profile is crazy lots of dynamic sql text and cursor fetches... the As&Ds look simple enough when you see a few edits on a version or two but the live data makes me think I'll miss something unless I know it's perfectly crafted. 

Current strategy is:

SQL sproc:

cursor over version names

set_current_version

select OIDs to temp (use editor tracking columns if it helps)

merge against base temp OIDs 

do some tweaks for special cases

...

we'll see 

 

0 Kudos