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

[Bruce Markey]

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
-------------- next part --------------
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