Manual Scheduling

[jcole998]

I've written the SQL statement below to retrieve programs rows from EPG_EVENT. Essentially, it retrieves unique(DISTINCT) rows having a title starting with "ncis" and a subtitle starting with "b", without regard to time or channel. It returns 6 rows. It returns 18 rows without the DISTINCT keyword and includes duplicates scheduled at different times.

SELECT DISTINCT title, subtitle FROM EPG_EVENT WHERE title LIKE "ncis%" AND subtitle LIKE "b%"

How can I tell NextPVR to find these same distinct rows and schedule the programs returned? How do I get NextPVR to do this at each EPG download?

Hope someone can help.

Thanks.

[sub]

You can use the Advanced Rules to specify the title LIKE "ncis%" AND subtitle LIKE "b%" bit of this, but you can't do the DISTINCT part of it.

That said, if you're using Schedules Direct, and have 'avoid recording duplicates where possible', then it's not going to record duplicates, and should give you the same effect.

[jcole998]

Thanks for the help, sub. I'll see how it works.