What is the way to do this? I want to be able to read the gdb_from_date and gdb_to_date fields of the archive table using arcpy. How do you instantiate the archived table?
I figured out that you need to make a query layer in order to access this information from arcpy. Script looks like this:
<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> os collector_db_con <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"Database Connections\CollectorSpatialData_CollectorWriter.sde"</SPAN> output <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeQueryLayer_management<SPAN class="punctuation token">(</SPAN>collector_db_con<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Out"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"select * from COVEYCOUNT where GDB_TO_DATE = '2019-09-30 13:56:44.4300000'"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN></SPAN>
Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
