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

[Gabe O'Brien <gabe.obrien@xxxxxxxxxxx>]

Today was one of those super busy days where about 10 new things got 
added to my plate as I was in the middle of finishing up a hand full of 
other things.

I should be able to get the reports with the queries that Scott gave 
setup sometime tomorrow.  Will a standard CSV file work as the output?

gO'

Scott Rosenbaum wrote:
> 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
>
>
>