Combine a program's various times into single row in view [#644120]

Hey drewish,

First off, thanks for your work on station, it's much appreciated.

I'm getting up-to-speed on all of the updates in station from 5.x to 6.x. The use of views is great, but I'm having trouble with my scheduled program view. I have programs which are scheduled on multiple days, but not the same time of day. The second occurrence in the schedule is always a replay of the program and I'd like to display each in a combined row.

I don't see a way to handle grouping these in the view and distinct seems to be just an SQL SELECT DISTINCT.

Any idea on how I might accomplish this grouping?

Comment	File	Size	Author
#4	Screen shot 2009-11-28 at 1.49.48 PM.png	123.75 KB	thumb
#2	schedule.png	38.64 KB	thumb

Comments

Comment #1

drewish commented 27 November 2009 at 00:53

i'm not quite sure what you're trying to do but if you want a program centric view you should use 'node' as the base if you want a time centric view you should use 'schedule item'. does that make any sense?

Comment #2

thumb commented 28 November 2009 at 00:21

Status	File	Size
new	schedule.png	38.64 KB

A picture's worth a thousand words. On the left is my Drupal 5 station schedule, the right is the Drupal 6 version. I'm not quite sure I follow the node vs. schedule item approach.

Comment #3

drewish commented 28 November 2009 at 20:37

yeah that's very helpful. which view is that of? one of the default views or a custom one you've created?

Comment #4

thumb commented 28 November 2009 at 20:50

Status	File	Size
new	Screen shot 2009-11-28 at 1.49.48 PM.png	123.75 KB

It's a default view, path is /station/programs/scheduled. Here's the view definition.

Comment #5

drewish commented 14 December 2009 at 06:33

Category:

support

» feature

okay spent a little time looking at this. i know a lot more about the way that cck's relationship handler works now. i think we can get this working but it'll take some more time than i've got right now.