Ability to delete a single recording from the recently_deleted table

[cbgifford]

Hello,

What I want to be able to clear Recording History for individual episodes.

I record older television shows for my video library and don't delete them after watching since I enjoy watching them multiple times. I've set the advanced configuration setting to 9999 so they don't record again. On occasion, a recording either gets messed up or accidentally deleted and I need to be able to record the episode again the next time it airs.

I've looked at the NPVR.DB3 database and see the scheduled_recording table that stores all the recordings that have been recorded or are scheduled to be record. In the Recently_deleted table I can see the unique_identifier field that correlates to the unique_id field in the EPG_Event table so NPVR knows not to record it again. However, I don't see this field in the scheduled_recordings table. I'd like to be able to delete the one episode from the recently_deleted table. I know it's being stored somewhere because you're adding it when NPVR deletes the recording but I don't see how you are relating the scheduled_recording record to the unique_id data in the EPG

I'm an accomplished database programmer and would be more than willing to develop a small utility to accomplish this and share it with the community as well as any other utilities I might develop in the future if you would be willing to share how you are relating the recently_deleted table to the scheduled_recordings table when you delete a recording.

I did search the forums and you indicated in one post that when a recording is flagged as failed for whatever reason, it would not be added to the recently_deleted table. I could possibly set the status to a failed indication or update the failure_reason field and let NPVR manage the recently_deleted table.

I look forward to a long association with the NPVR community.

Signed,
An ex-Beyond TV user

[sub]

The unique id is in the EPG_EVENT table. It uses this to decide if it creates a SCHEDULED_RECORDING entry. ie, you'd need to find the unique id from the EPG_EVENT table for the show in question, and delete it from the RECENTLY_DELETED table.

[cbgifford]

The unique id is in the EPG_EVENT table. It uses this to decide if it creates a SCHEDULED_RECORDING entry. ie, you'd need to find the unique id from the EPG_EVENT table for the show in question, and delete it from the RECENTLY_DELETED table.

Understand that but the scheduled_recording table does not the unique_id field unless...

Ahhh! I found it! The SQLite db browser I'm using did not show all the data in event_details field unless I tried to edit it. That field contains an XML structured string!