Discussion about the Pentabarf conference planning software

Dan Langille | 4 Feb 2010 02:38

report/review - add a column for speaker?

report/review is great in that we can sort by each column (event name, 
state, track, rating, and raters).  But we are unable to sort by 
speaker.  Often, we get multiple submissions from the same person, and 
it is useful to sort by speaker.

Is it practical to split speaker out into its own column for this.  I 
see problems for talks with multiple speakers though....

In the meantime, we are doing this:

SELECT CT.conference_track AS track, VP.name AS speaker,VP.title AS talk
  FROM view_event_person VP JOIN event E ON VP.event_id = E.event_id
        JOIN conference_track CT ON E.conference_track_id = 
CT.conference_track_id
WHERE VP.conference_id = 6
   AND VP.event_role    = 'speaker'
   AND VP.translated    = 'en'
ORDER BY track;

headers

Sven Klemm | 6 Feb 2010 15:52

Re: report/review - add a column for speaker?

Hi there,

Dan Langille wrote:
> report/review is great in that we can sort by each column (event name,
> state, track, rating, and raters).  But we are unable to sort by
> speaker.  Often, we get multiple submissions from the same person, and
> it is useful to sort by speaker.
> 
> Is it practical to split speaker out into its own column for this.  I
> see problems for talks with multiple speakers though....

the purpose of the review report is to have a list of all events with
highlighting which events you haven't rated yet. Maybe there should be
a new report listing all the submissions. What do you want to achieve
with sorting by speaker? Identifying duplicate submissions?

Cheers,
Sven

--

-- 
Sven Klemm
http://cthulhu.c3d2.de/~sven/

headers

Dan Langille | 6 Feb 2010 17:20

Re: report/review - add a column for speaker?

Sven Klemm wrote:
> Hi there,
> 
> Dan Langille wrote:
>> report/review is great in that we can sort by each column (event name,
>> state, track, rating, and raters).  But we are unable to sort by
>> speaker.  Often, we get multiple submissions from the same person, and
>> it is useful to sort by speaker.
>>
>> Is it practical to split speaker out into its own column for this.  I
>> see problems for talks with multiple speakers though....
> 
> the purpose of the review report is to have a list of all events with
> highlighting which events you haven't rated yet. Maybe there should be
> a new report listing all the submissions. What do you want to achieve
> with sorting by speaker? Identifying duplicate submissions?

Not duplicate, but multiple.  Sometimes we get 4 submissions from a 
speaker.  We like to know that as part of our review process.  We might 
want only one talk from that speaker, but we'd take two from another. 
It is easy to overlook multiple submissions from the same person out of 100.