Search guide for Series

[Bobbybear]

Using NextPVR v5.2.6.220206
I want to use the search function to create recordings for the episodes of a series I have missed.
Example:
I missed the start of Series 5 of Bangers and Cash on the "Yesterday" channel.
I can search for 'Bangers and Cash' but it comes up with 88 episodes only 5 of which are for Series 5
The series description starts with the usual S05E03 etc but if I put S05 in the 'description text' the search finds nothing!
I'm using Schedules Direct as a source, but I don't think that should not make any difference.
How can I create a manual recording "advanced 'title like '%bangers and Cash%' ' but for Series 5 episode only?

[mvallevand]

From Schedules Direct, the S/E won't actually be in the description, they are unique fields. I gave an example for an advanced recording here https://forums.nextpvr.com/showthread.ph...#pid549046 When the create search manual recording popup opens just add the field qualifiers you need.

Martin.

[Bobbybear]

Interesting. That works but only if I use this string: title like '%Bangers and Cash%' and season = 5 and episode = 1
Then put a recurring event for each missing episode.
I cannot seem to just use: title like '%Bangers and Cash%' and season = 5
to get it to find all episodes from the season or is that a quirk of SQL

[mvallevand]

Odd. Turn on on verbose logging, (ctrl on setttings screen) and submit the search and send the zipped logs. We can see the sql that is generated that way.

Martin

[Bobbybear]

Hi Martin
Enabled Verbose logging and created query series only,
zip log file sent

Bob

[sub]

It looks like it worked. There was a pile of episodes that match, but they weren't scheduled because either you've already got them scheduled to record, or you've recently deleted them:

2022-04-04 16:35:22.347 [INFO][22] UpdateRecurringRecording(276, 'All Channels'):
<Rules>
<ChannelOID>0</ChannelOID>
<ChannelName>All Channels</ChannelName>
<StartTime>2022-04-04T16:35:22.3242849+01:00</StartTime>
<EndTime>2022-04-04T16:35:22.3242858+01:00</EndTime>
<PrePadding>15</PrePadding>
<PostPadding>15</PostPadding>
<Quality>0</Quality>
<Keep>0</Keep>
<RecordingDirectoryID>[Default]</RecordingDirectoryID>
<AdvancedRules>title like &apos;%Bangers and Cash%&apos; and season = 5</AdvancedRules>
</Rules>

2022-04-04 16:35:22.347 [VERBOSE][22] removeMissingRecordings=True
2022-04-04 16:35:22.348 [VERBOSE][22] checkForRenamedRecordings=True
2022-04-04 16:35:22.348 [VERBOSE][22] noRemoveWhenTreeMissing=True
2022-04-04 16:35:22.351 [VERBOSE][22] removeMissingRecordings=True
2022-04-04 16:35:22.351 [VERBOSE][22] checkForRenamedRecordings=True
2022-04-04 16:35:22.351 [VERBOSE][22] noRemoveWhenTreeMissing=True
2022-04-04 16:35:22.363 [DEBUG][22] LoadListingByAdvancedRules(channel='all channels',advancedRules=title like '%Bangers and Cash%' and season = 5)
2022-04-04 16:35:22.483 [DEBUG][22] - Potential episode at: 05/04/2022 22:00:00
2022-04-04 16:35:22.486 [DEBUG][22] ...check IsValid()
2022-04-04 16:35:22.486 [DEBUG][22] ...already got this episode: EP031978930050 (recently deleted)
2022-04-04 16:35:22.486 [DEBUG][22] ...already got this episode scheduled
2022-04-04 16:35:22.486 [DEBUG][22] - Potential episode at: 05/04/2022 23:00:00
2022-04-04 16:35:22.487 [DEBUG][22] ...check IsValid()
2022-04-04 16:35:22.487 [DEBUG][22] ...already got this episode: EP031978930050 (recently deleted)
2022-04-04 16:35:22.487 [DEBUG][22] ...already got this episode scheduled
2022-04-04 16:35:22.487 [DEBUG][22] - Potential episode at: 06/04/2022 22:00:00
2022-04-04 16:35:22.487 [DEBUG][22] ...check IsValid()
2022-04-04 16:35:22.487 [DEBUG][22] ...already got this episode: EP031978930042 (already pending)
2022-04-04 16:35:22.487 [DEBUG][22] ...already got this episode scheduled
2022-04-04 16:35:22.487 [DEBUG][22] - Potential episode at: 06/04/2022 23:00:00
2022-04-04 16:35:22.487 [DEBUG][22] ...check IsValid()
2022-04-04 16:35:22.487 [DEBUG][22] ...already got this episode: EP031978930042 (already pending)
2022-04-04 16:35:22.487 [DEBUG][22] ...already got this episode scheduled
2022-04-04 16:35:22.487 [DEBUG][22] - Potential episode at: 07/04/2022 20:00:00
2022-04-04 16:35:22.487 [DEBUG][22] ...check IsValid()
2022-04-04 16:35:22.488 [DEBUG][22] ...already got this episode: EP031978930051 (already pending)
2022-04-04 16:35:22.488 [DEBUG][22] ...already got this episode scheduled
2022-04-04 16:35:22.488 [DEBUG][22] - Potential episode at: 07/04/2022 21:00:00
2022-04-04 16:35:22.488 [DEBUG][22] ...check IsValid()
2022-04-04 16:35:22.488 [DEBUG][22] ...already got this episode: EP031978930051 (already pending)
2022-04-04 16:35:22.488 [DEBUG][22] ...already got this episode scheduled
2022-04-04 16:35:22.488 [DEBUG][22] - Potential episode at: 08/04/2022 21:00:00
2022-04-04 16:35:22.488 [DEBUG][22] ...check IsValid()
2022-04-04 16:35:22.488 [DEBUG][22] ...already got this episode: EP031978930051 (already pending)
2022-04-04 16:35:22.488 [DEBUG][22] ...already got this episode scheduled
2022-04-04 16:35:22.488 [DEBUG][22] - Potential episode at: 08/04/2022 22:00:00
2022-04-04 16:35:22.488 [DEBUG][22] ...check IsValid()
2022-04-04 16:35:22.488 [DEBUG][22] ...already got this episode: EP031978930044 (already pending)
2022-04-04 16:35:22.488 [DEBUG][22] ...already got this episode scheduled
2022-04-04 16:35:22.488 [DEBUG][22] - Potential episode at: 08/04/2022 22:00:00
2022-04-04 16:35:22.488 [DEBUG][22] ...check IsValid()
2022-04-04 16:35:22.488 [DEBUG][22] ...already got this episode: EP031978930051 (already pending)
2022-04-04 16:35:22.488 [DEBUG][22] ...already got this episode scheduled
2022-04-04 16:35:22.488 [DEBUG][22] - Potential episode at: 08/04/2022 23:00:00
2022-04-04 16:35:22.488 [DEBUG][22] ...check IsValid()
2022-04-04 16:35:22.488 [DEBUG][22] ...already got this episode: EP031978930044 (already pending)
2022-04-04 16:35:22.488 [DEBUG][22] ...already got this episode scheduled
2022-04-04 16:35:22.488 [DEBUG][22] - Potential episode at: 10/04/2022 23:00:00
2022-04-04 16:35:22.488 [DEBUG][22] ...check IsValid()
2022-04-04 16:35:22.488 [DEBUG][22] ...already got this episode: EP031978930051 (already pending)
2022-04-04 16:35:22.488 [DEBUG][22] ...already got this episode scheduled
2022-04-04 16:35:22.488 [DEBUG][22] - Potential episode at: 11/04/2022 00:00:00
2022-04-04 16:35:22.488 [DEBUG][22] ...check IsValid()
2022-04-04 16:35:22.488 [DEBUG][22] ...already got this episode: EP031978930051 (already pending)
2022-04-04 16:35:22.488 [DEBUG][22] ...already got this episode scheduled
2022-04-04 16:35:22.488 [DEBUG][22] - Potential episode at: 12/04/2022 22:00:00
2022-04-04 16:35:22.488 [DEBUG][22] ...check IsValid()
2022-04-04 16:35:22.488 [DEBUG][22] ...already got this episode: EP031978930051 (already pending)
2022-04-04 16:35:22.488 [DEBUG][22] ...already got this episode scheduled
2022-04-04 16:35:22.488 [DEBUG][22] - Potential episode at: 12/04/2022 23:00:00
2022-04-04 16:35:22.488 [DEBUG][22] ...check IsValid()
2022-04-04 16:35:22.489 [DEBUG][22] ...already got this episode: EP031978930051 (already pending)
2022-04-04 16:35:22.489 [DEBUG][22] ...already got this episode scheduled
2022-04-04 16:35:22.489 [DEBUG][22] {"stat":"ok"}

[Bobbybear]

Hi Sub
Thanks for that, I did not realise that delete recordings were logged.
I have set series query up again and will watch to see if new episodes appear in the EPG and if it marks them to record.
Thanks for the help
Bob

[jcjefferies]

Some months ago I could not understand why I wasnt recording the latest series of "Bangers & Cash". Eventually I created a new Recurring Recording from the EPG which worked so looked at the Recurring Recording list where there was an obvious difference between the two entries! The original series I recorded had been called "Bangers and Cash" and since then all have been called "Bangers & Cash". This would not have been a problem for Freesat or Freeview recorders as they use the "Series ID" not the title to identify the items to record!!

[mvallevand]

For that case maybe try

title like 'Bangers % Cash'

Martin

[jcjefferies]

I already use the "%" for some recordings where I expect extra words to be added at the beginning, middle or end of the title.

I notice using the "Search" option that "Escape to the country" and "Escape To The Country" have separate entries but in this case seems to be an identical list of programmes. In other cases the lower and upper case variation give a slightly different list of recordings. I also found several cases where "!" had been sometimes added to the end of the title and "-" added to the middle of the title which does not help!!