[mythtvnz] Detect missing schedule items

[Dean Pemberton]

Toby Mills wrote:

> Record anything at anytime where title contains (Dr or Doctor) and Who<br>
> Record anything on channel one where title contains "news"<br>
> Record anything on channel X, Y and Z where category is Comedy<br>
>

Ask and ye shall receive.

There is a way to do this with Myth (Mythweb in my case)
you use a Power Search.

I managed to record B&S last night and I've caught McLeods doing the same
thing, thus keeping WAF high.

If you go into Custom Recording Profiles  (I'm doing this from memory
because I'm on a cellphone from a Sydney hotel at the moment =) )
Then there is a section where you can define a custom recording profile,
funnily enough.

Now make sure you select "Power Search" instead of something like "Title
Search" or "Keyword Search".

Enter something in the Title box which is meaningfull to you, it doesn't
have to be the title of the show.

Now in the box Two down from that (I can't remember what it's called at
the moment) you enter an SQL search string to match shows with.

This is the most powerfull way to match things. Here are some examples

program.title LIKE "Brothers and Sisters"
(will just do an exact match - now really helpfull to us.)

program.title LIKE "Brothers%Sisters"
(This will match any show with starts with Brothers then has anything in
the middle and the word Sisters at the end.)

program.title LIKE "Brothers%Sisters%"
(This one is like the above but will also allow things after the Sisters)

Now - this is a bit too broad if you have sky as there are all sorts of
programs on those other channels which might match this.  Something on
discovery about genetics or something.  So you'll want to narrow it down.


program.title LIKE "Brothers%Sisters%" AND channel.callsign LIKE "TV2"
(So now we've narrowed it down to Things on TV2)

We can also narrow it down to a particular day
program.title LIKE "Brothers%Sisters%" AND channel.callsign LIKE "TV2" AND
DAYOFWEEK(program.starttime) == "2"

Sunday =1, Monday =2 etc

So to do the examples you had at the top of the message (SQL experts could
probably optimise these)...



> Record anything at anytime where title contains (Dr or Doctor) and Who

program.title LIKE "Dr%Who%" OR program.title LIKE "Doctor%Who"


> Record anything on channel one where title contains "news"<br>

program.title LIKE "%news%" and channel.callsign LIKE "TV1"

> Record anything on channel X, Y and Z where category is Comedy<br>
>

program.category LIKE "Comedy" and channel.callsign LIKE "X" or
channel.callsign LIKE "Y" or channel.callsign LIKE "Z"

That last one might need some work but you get the idea.

The best one I have is to catch the evening news on One.

I have a rule which tapes anything on TV1 with the words "One" and "News"
in it between the hours of 5 and 10 in the evenings.

Have fun.

I've changes almost all my recording searches to this type.  And I find
that I catch a whole lot more programs.

You can also check out this URL for some more examples
http://www.mythtv.org/docs/mythtv-HOWTO-12.html#ss12.5


Dean