search

cityofaustin / atd-knack-signs-markings

https://atd-knack-signs-markings.netlify.com/
Other
1 stars 0 forks source link

Delete "csr_flex_notes" from Signs and Markings - Dec 2019 #281

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

Ran filter on: https://builder.knack.com/atd/signs-markings#data/object_172/records

Filter: ISSUE_STATUS_CODE contains closed CREATED_DATE is before 10/01/19

Total Records: 25,922 To Delete: 5,579 (number of records from running the query) New Total: 20,343

Run Batch Delete Same query Filter: ISSUE_STATUS_CODE contains closed CREATED_DATE is before 10/01/19

SurbhiBakshi commented 4 years ago

image.png

image.png

SurbhiBakshi commented 4 years ago

image.png

SurbhiBakshi commented 4 years ago

image.png

SurbhiBakshi commented 4 years ago

2nd attempt started at 11:10 am image.png

SurbhiBakshi commented 4 years ago

@johnclary , still can't do a batch delete process that takes care of all records to be deleted (5,579) at once. Also, the process takes way longer than Data Tracker, although I had to delete more records in Data Tracker.

image.png

johnclary commented 4 years ago

that's troubling. would you open a knack issue? i see this as related to our performance issue.

SurbhiBakshi commented 4 years ago

@johnclary will open a Knack issue

SurbhiBakshi commented 4 years ago

@johnclary Submitted Knack issue

SurbhiBakshi commented 4 years ago

Created an issue to follow the bug resolution by Knack. [#298] (https://app.zenhub.com/workspaces/data--technology-services-5caf7dc6ecad11531cc418ef/issues/cityofaustin/atd-knack-signs-markings/298)