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>
Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
