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

["Scott Rosenbaum" <scottr@xxxxxxxxxxxxxxxxxxxxx>]

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