search

cityofaustin / atd-knack-data-tracker

The primary work & asset management system for Austin Transportation
3 stars 1 forks source link

Delete "csr_flex_notes" from Data Tracker - Sept 2019 #220

Closed dianamartin closed 5 years ago

dianamartin commented 5 years ago

Received automated reminder to delete flex notes in Data Tracker PROD and reference the Flex Note Archiving wiki

Ran filter on: https://builder.knack.com/atd/amd#data/object_95/records

Filter: ISSUE_STATUS_CODE contains closed CREATED_DATE is before 7/31/19

Total Records: 38,887 To Delete: 12,015 (number of records from running the query) New Total: 26,872

dianamartin commented 5 years ago

Run Batch Delete Same query Filter: ISSUE_STATUS_CODE contains closed CREATED_DATE is before 6/30/19 image

dianamartin commented 5 years ago

Showed @SurbhiBakshi the CSR Flex Notes Archiving steps, she will do this week for Signs and Markings.