RE: [eclipse.org-eclipsecon-program-committee] Authors Report

["Scott Rosenbaum" <scottr@xxxxxxxxxxxxxxxxxxxxx>]

All,

I have added a new sheet to the Requested Talks - Updatable spread-sheet
which provides a break-down (by author, by talk type) for accepted talks.
The goal is to make sure that the limited time on the stage is spread around
a bit.  

It is tough to limit peoples time on the stage.  It just makes sense that
the people who have done most of the work, are the best to talk about the
work they have done.  That said each year I have seen a couple of people end
up with a disproportionate number of talks, because they were the experts.  

I figure that as we come down to the wire and have to make some hard
decisions, number of talks per author should be a factor in the decision
process.  I will attempt to keep this up to date and reasonably accurate as
things change.

Scott

-----Original Message-----
From: eclipse.org-eclipsecon-program-committee-bounces@xxxxxxxxxxx
[mailto:eclipse.org-eclipsecon-program-committee-bounces@xxxxxxxxxxx] On
Behalf Of Scott Rosenbaum
Sent: Thursday, January 07, 2010 8:46 PM
To: 'Eclipsecon Program Committee list'
Subject: RE: [eclipse.org-eclipsecon-program-committee] Authors Report

Oisin,

Sorry, doing a training tomorrow and the wheels fell off.  Such is life.

Unfortunately, you can't run that query from outside the foundation. It has
to be run by Gabe or one of the sys admins from within the foundation (we
can't run queries against the DB directly).  Last year I was given a DB
extract to build my reports.  

This year Gabe had talked about giving you a command as PC chair that would
allow you to run the report on demand.  Not sure where this stands with
Gabe.

Scott

-----Original Message-----
From: eclipse.org-eclipsecon-program-committee-bounces@xxxxxxxxxxx
[mailto:eclipse.org-eclipsecon-program-committee-bounces@xxxxxxxxxxx] On
Behalf Of Oisin Hurley
Sent: Thursday, January 07, 2010 8:15 PM
To: Eclipsecon Program Committee list
Subject: Re: [eclipse.org-eclipsecon-program-committee] Authors Report

Hi Scott,
Ok, got the query, it had ended up filed in the wrong mailbox - how do
I run this again? My memory is a bit mushy on the topic.

I assume we are talking about the query to find authors with more than
2 talks? (see below)

 --oh

SELECT sa.personID, count(*) num_accepted

FROM submission_authors sa

inner join submissions s on s.submission_id = sa.submission_id

where s.conference_id = 5

and tentative_status = 'tentative_accept'

and role = 'author'

group by personID

having count(*) > 2

order by num_accepted desc, personId;
_______________________________________________
eclipse.org-eclipsecon-program-committee mailing list
eclipse.org-eclipsecon-program-committee@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipse.org-eclipsecon-program-comm
ittee


_______________________________________________
eclipse.org-eclipsecon-program-committee mailing list
eclipse.org-eclipsecon-program-committee@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipse.org-eclipsecon-program-comm
ittee