Finding items in future schedules

English General
1

Hi all

Is there a way of finding when a track occurs in future schedules (a bit like the history which shows when it has been played in the past?)

I stupidly forgot to put an end date on a promo for Christmas Eve which I have now discovered is scheduled in January so need to find out what hours it appears in so I can remove it! I can’t create new schedules as some of the hours have already been voicetracked!

Any ideas (apart from go through each hour individually) would be appreciated.

Regards

Ron.

2

In the SQL console (Help menu):

SELECT slot FROM playlist WHERE item=1234 ORDER BY slot DESC

Replace 1234 with the actual ID of the item you’re looking for.

3

Belated thanks Torben - that worked a treat!

I tried to use this method to find future schedules for a specific advert within an advert container but it doesn’t appear to look inside a container for the reference number. Is that a simple mod to the SQL code or something a bit more involved?

Regards

Ron.

4

Torben - any thoughts on if it is easy to find adverts from within containers?

Thanks

Ron.

5

Almost impossible, as nested items are stored inside an XML block :frowning:

6

OK. Shame but thanks again for the original code works well on standard items.

Ron.