Bulk-inactivating lists

Hi Erin,

There was a similar discussion on the forums a year+ ago: https://community.tessituranetwork.com/tessitura_software_forums/f/tessitura_technical-9/24883/deleting-lists/75426#75426

I'm happy to share the utility I wrote to clean up old lists, extractions, and output sets. Feel free to email me and I'll send it over. 

Madeline Dummerth (Past Member)'s suggestion is also good if you have a specific set of lists in mind! :)

Katie, thanks for pointing me to that previous discussion - I'd love to get your utility if I can! 

Madeline, appreciate the SQL! There doesn't seem to be a consistent naming convention - I'm trying to find a way to inactivate lists based on 'last generated' date instead, thinking that a very old 'last generated' date would be a good indicator if the list is still being used 

That report sounds wonderful Katie Lachance-Duffy  - could I bug you for a copy?  It seems to be missing from https://www.tessituranetwork.com/Support/Resources/Shared-Reports 

Riffing off Madeline Dummerth (Past Member)

You could run this and seeing if it works for you.  Change the '2022-01-01' to the date of the last useful generation that works for you.

use impresario
Select * from T_LIST 
where last_used_dt < '2022-01-01'
and tms = 'N'
and tstats  = 'N' 

and it that looks good

BEGIN  TRANSACTION

UPDATE  T_LIST 
SET inactive = 'Y'
WHERE last_used_dt < '2022-01-01'
and tms = 'N'
and tstats  = 'N' 
and inactive = 'N'

SELECT * from T_list 
WHERE  last_used_dt < '2022-01-01'
and tms = 'N'
and tstats  = 'N' 

ROLLBACK TRANSACTION

-- change rollback to commit if happy and run again


-- change rollback to commit if happy and run again

Thanks Heath, I'll give this a try and double back with questions!

Thanks Heath, I'll give this a try and double back with questions!