LinHES Forums
http://forum.linhes.org/

What's wrong with this power search?
http://forum.linhes.org/viewtopic.php?f=17&t=16278		 Page 1 of 1
Author:  mihanson [ Thu Aug 30, 2007 3:20 pm ]
Post subject:  What's wrong with this power search?
Ok, I'm about to bang my head on the desk. Here's why... I'm trying to use MythWeb to create a custom power search for a handful of "Family Guy" episodes I don't already have. I select the following:

    Record at any time on any channel.
    Power Search
    Search Title: Family Guy (Missing Eps)
    Search Phrase:
    Code:
    program.title = 'Family Guy' AND (program.subtitle = 'Stewie B. Goode' OR program.subtitle = 'Bango Was His Name Oh' OR program.subtitle = 'Stu & Stewie's Excellent Adventure' OR program.subtitle = 'It Takes a Village Idiot, and I Married One') AND (channel.callsign = 'KTTVDT%' OR channel.callsign = 'KTLADT%')

    Date & Time left at defaults (Sunday 00:00:00)
    Recording Profile: High Quality
    Transcoder: Autodetect
    Recording Group: Humor
    Recording Priority: 3
    Check for duplicates in: All Recordings
    Duplicate Check method: None
    Auto Commercial Flag checked
    Auto Expire Unchecked
    Start 1 min early
    End 1 min late

When I press the Save Schedule button, the page refreshes. Everything is still there after the refresh, but the
Quote:
Record at any time on any channel.
radio button is no longer selected (nothing is). Click the radio button again and save. Same deal. I navigate back to Recording Schedules and my custom power search (Family Guy (Missing Eps)) is not there. I refresh the page and it's still not there. I've also tried without all the parenthesis () in the Search Phrase. What the frick am I doing wrong? :evil:
Author:  Liv2Cod [ Thu Aug 30, 2007 5:18 pm ]
Post subject: 
Could it have anything to do with the "Stu & Stevie's" phrase? I see it uses a single-quote, which you also used to delimit the strings (you may need to escape that somehow). The ampersand is sometimes a reserved character in some SQL character sets, but it should be protected by the quotes in this use.
Author:  mihanson [ Thu Aug 30, 2007 5:54 pm ]
Post subject: 
Liv2Cod, Thank you! That did the trick. Here's my new search phrase that works:

Code:
program.title = 'Family Guy' AND (program.subtitle = 'Stewie B. Goode' OR program.subtitle = 'Bango Was His Name Oh' OR program.subtitle LIKE '%Excellent Adventure' OR program.subtitle = 'It Takes a Village Idiot, and I Married One') AND (channel.callsign = 'KTTVDT%' OR channel.callsign = 'KTLADT%')


I removed the "Stu & Stewie's" and went with the wildcard in it's place.
Author:  myth19kirt [ Fri Nov 30, 2007 9:57 am ]
Post subject:  Use this power search to get all of the Christmas specials
I use the following power search to get all of the Christmas specials for my kids. :P

1 Goto mythweb and click Recording Schedules CUSTOM.
2 Change type to Power Search.
3 Enter into Search Phrase.
Code:
program.category LIKE 'Holiday-children%'

4 Give it a nice Title.
5 Increase the record priority above less important recordings.
6 I record 1 minute early and end 1 minute late just to be sure of getting everyting, but watch out for conflicts.
7 Back in mythweb I view the Upcomming recordings and choose to NEVER record those shows I know I don't want. (Mr T's Kwaanza extravaganza)
8 Remove this custom record schedule after Christmas, or leave it for other Holidays.

Thanks to mihanson!
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/