Possible to record only on specific channels using an SQL filter

[janoonk]

I have the same channels in two qualities for example "NPO 1" which is SD and "NPO 1 HD". So HD variant of a channel always ends with " HD"
I do my recording mostly on SD channels because of size and often enough it's good enough.

I wanted to record all movies with Christmas in the title but only for the SD channels so I added:

 and channel not like '% HD'

to the Advanced editfield but it doesn't work.

Second question: which fields are available? I know of title and genre. Where can I find documentation about this?

[Graham]

Second question: which fields are available? I know of title and genre. Where can I find documentation about this?

The select is querying fields in the EPG_EVENT table in the NextPVR database at npvr.db3. 

https://github.com/sub3/NextPVR/wiki/components

The channel column is channel_oid which points to the CHANNEL table ... You might be able to get the result that you want with something like ... channel_oid = (select blah from channel blah)

You are trying something that is a tad more complex than the advanced query was intended for.

The docs don't describe your use ... https://github.com/sub3/NextPVR/wiki/web...recordings

[janoonk]

The advanced field is using genre instead of genres.

I got it to work using this for the Advanced field when creating(!):

Code:

title like '%Christmas%' and genres like '%Movie / Drama%'
and channel_oid in (
   select oid from channel where name not like '% HD'
)

[mvallevand]

There is no documentation on using sqlite fields or now they are named or used. Feel free to contribute to the wiki.

Martin

[janoonk]

Also when you don't do anything fancy/advanced... it still doesn't work when you search for a title and a genre.
The field genre is used instead of genres. It's a bug.

[sub]

The field genre is used instead of genres. It's a bug.

Right you are. I've fixed it for the next release.

I don't think anyone has ever reported trying a genre based advanced recording from the search screen before. I suspect this has mainly only been used for searching, and it did work correctly for that.

[mvallevand]

I use the search genres a lot but I record from the shows it finds which is probably the typically use case.

Martin

[sub]

I use the search genres a lot but I record from the shows it finds which is probably the typically use case.

Yeah, I suspect that is a lot more common.

[janoonk]

The field genre is used instead of genres. It's a bug.

Right you are. I've fixed it for the next release.

I don't think anyone has ever reported trying a genre based advanced recording from the search screen before. I suspect this has mainly only been used for searching, and it did work correctly for that.

Thanks! They call me mister bug finder so expect more