search

cityofaustin / atd-knack-data-tracker

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

Delete CSR Flex Note records for closed SRs from Data Tracker that are older than 2 months #263

Closed SurbhiBakshi closed 4 years ago

SurbhiBakshi commented 4 years ago

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

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

Filter: ISSUE_STATUS_CODE contains closed CREATED_DATE is before 12/01/2019

Total Records: 35,875 To Delete: 10,865 (number of records from running the query) New Total: 25,010

SurbhiBakshi commented 4 years ago

image.png

SurbhiBakshi commented 4 years ago

image.png

SurbhiBakshi commented 4 years ago

image.png