archiving/cleaning up question_answer table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-24-2023 01:08 PM
hi all!
We are working on ticket (incident) data archiving and one of the related tables which poped up is question_answer. Interestingly I am not able to pick or see this table as related table for archiving, and of course we don't want to leave this table hanging with orphan records.
Before getting into custom scripting options and jobs for clean up, just wanted to double check if I am not missing anything, or maybe there is a more graceful options...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-25-2023 01:38 AM
Hi @Rim1,
I have tested it in a vancouver instance, and can confirm it is NOT working for the question_answer table unfortunately.
However, I can choose the question_answer table as table to cleanup.
Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-27-2023 12:42 AM
Table cleaner won't help here unfortunately. The intent is to archive/destroy tickets and related data (question_answer). Table cleaner doesn't have advanced condition scripting allowing to determine if question_answer record is actually orphan, and with simple condition builder I don't believe it is possible.
