[mythtv-users] View all upcoming movies without duplicates?

[John Patrick Poet]

Bruce Markey wrote:

> Dan Wilga wrote:
>
>> As we all know, movie channels like to show the same film over and 
>> over. As it stands, Myth's Movies listing is huge, because is shows 
>> the same films many times. Finding movies I'd like to record takes a 
>> really long time, because of all the duplicates.
>
>
> It's also huge because there are a lot of different titles. Showing
> each title once would shorten the list for a few days in the future
> but would barely have any impact in the first couple hours of this
> time sorted list. If you are looking ahead to a certain time frame
> to see what you might watch then, there would be valid choices missing.
> Also, say you have both HBO and HBOP 3 hours delayed. At 8:45 you
> spot a movie you'd like to see that is on HBO from 7-9 and is about
> to end. It wouldn't show you that it's on again in about an hour from
> 10-12 on HBOP.
>
>> What I'd like to be able to do is see all upcoming movies, but not 
>> list the same title more than once. Ideally, when I click on a title, 
>> I would be able to see all upcoming showings of that movie, and 
>> choose which one to record.
>
>
>
> I can think of several reasons not to do this by default but this
> should give you what you describe. The attached would have been a
> one liner but it's two so that it also addresses the HBO example
> above.
>
>> I can't see any way to do this with either the Movies or Advanced 
>> listings. Am I missing something, or is it not currently possible?
>
>
> Don't over look the HOME and END keys to filter by stars. This is
> probably a much more effective chop the list down to just things
> you might actually watch.
>
> --  bjm
>
>------------------------------------------------------------------------
>
>Index: libs/libmythtv/proglist.cpp
>===================================================================
>RCS file: /var/lib/mythcvs/mythtv/libs/libmythtv/proglist.cpp,v
>retrieving revision 1.57
>diff -u -r1.57 proglist.cpp
>--- libs/libmythtv/proglist.cpp	6 Mar 2005 17:00:13 -0000	1.57
>+++ libs/libmythtv/proglist.cpp	27 Mar 2005 15:05:48 -0000
>@@ -1407,9 +1407,10 @@
>     else if (type == plMovies) // list movies
>     {
>         where = QString("WHERE channel.visible = 1 "
>-                        "  AND program.endtime > %1 "
>+                        "  AND program.starttime > %1 "
>                         "  AND program.category_type = 'movie' "
>-                        "  AND program.stars >= '\%2' ")
>+                        "  AND program.stars >= '\%2' "
>+                        "GROUP BY program.title ")
>                         .arg(startstr).arg(qphrase);
>     }
>     else if (type == plTime) // list by time
>  
>
>------------------------------------------------------------------------
>

I just submitted a patch to the dev list which uses the 1/2 keys to 
switch between the normal "All" view and a "Unique" view.  This works 
for Movies, Categories and Channels.

Not being a SQL expert, the above example was very usefull.  Thanks Bruce.


John