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

Help with powersearch expression for nascar
http://forums.linhes.org/viewtopic.php?f=17&t=16231		 Page 1 of 1
Author:  rsay [ Sun Aug 26, 2007 3:19 pm ]
Post subject:  Help with powersearch expression for nascar
I have set up the following powersearch to get live nascar races:

program.title = ('Nascar Racing')
AND program.subtitle REGEXP '(Nextel Cup)'
AND program.first > 0
AND program.previouslyshown = 0
AND program.category = ('Sports Event')

The only problem with this expression is that we pick up Practice, Final Practice and Qualifying in addition to the race. How do I modify the expression to exclude events that contain the word 'Practice' or 'Qualifying'
Author:  mihanson [ Sun Aug 26, 2007 4:24 pm ]
Post subject: 
How about adding this to the end of your search criteria:

Code:
AND program.description NOT ('Qualifying')
AND program.description NOT ('Practice')


I'm unsure if 'NOT' is the correct syntax (maybe '!=' instead?) but I'm sure someone more versed can chime in an correct that if it's wrong. That should give you a push in the right direction.
Author:  rsay [ Sun Aug 26, 2007 5:19 pm ]
Post subject: 
Thanks, that helped me narrow my guessing. I'm not sure if this is the correct way but... here's what I came up with that seems to work:

program.title = ('Nascar Racing')
AND program.subtitle REGEXP '(Nextel Cup)'
AND program.first > 0
AND program.previouslyshown = 0
AND program.category = ('Sports event')
AND program.subtitle NOT LIKE '%Practice'
AND program.subtitle NOT LIKE '%Qualifying'
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/