Last updated June 15, 2013. Created on June 15, 2013.
Edited by xjm. Log in to edit this page.

  1. Current threshold issues

    select pi.nid, pi.last_comment_id, pi.category, pis.name as status, pip.name as priority, pi.component, from_unixtime(n.created) as first_posted,  from_unixtime(n.changed) as last_updated
    from project_issues pi
    inner join node n on n.nid = pi.nid
    inner join project_issue_state pis on pis.sid = pi.sid
    inner join project_issue_priority pip on pip.priority = pi.priority
    where pi.pid=3060 -- core
    and pi.sid in(1, 4, 8, 13, 14) -- active, postponed, NR, NW, RTBC
    and pi.priority in(1, 4) -- critical, major
    and pi.category in ('bug', 'task')
    and pi.rid=572834 -- 8.x
    order by pi.nid desc
    ;
  2. Current threshold issue IDs and tags

    select distinct pi.nid, td.name as tag
    from project_issues pi
    inner join project_issue_state pis on pis.sid = pi.sid
    inner join project_issue_priority pip on pip.priority = pi.priority
    inner join term_node tn on tn.nid = pi.nid
    inner join term_data td on tn.tid = td.tid
    where pi.pid=3060 -- core
    and pi.sid in(1, 4, 8, 13, 14) -- active, postponed, NR, NW, RTBC
    and pi.priority in(1, 4) -- critical, major
    and pi.category in ('bug', 'task')
    and pi.rid=572834 -- 8.x
    group by tag
    order by pi.nid desc
    ;
  3. Number of current threshold issues per component

    select count(pi.nid) as issues, pi.component
    from project_issues pi
    where pi.pid=3060 -- core
    and pi.sid in(1, 4, 8, 13, 14)  -- active, postponed, NR, NW, RTBC
    and pi.priority in(1, 4) -- critical, major
    and pi.category in ('bug', 'task')
    and pi.rid=572834 -- 8.x
    group by pi.component
    order by issues desc
    ;
  4. Number of current threshold issues per tag

    select count(distinct pi.nid) as issues, td.name as tag
    from project_issues pi
    inner join project_issue_state pis on pis.sid = pi.sid
    inner join project_issue_priority pip on pip.priority = pi.priority
    inner join term_node tn on tn.nid = pi.nid
    inner join term_data td on tn.tid = td.tid
    where pi.pid=3060 -- core
    and pi.sid in(1, 4, 8, 13, 14) -- active, postponed, NR, NW, RTBC
    and pi.priority in(1, 4) -- critical, major
    and pi.category in ('bug', 'task')
    and pi.rid=572834 -- 8.x
    group by tag
    order by issues desc
    ;

Looking for support? Visit the Drupal.org forums, or join #drupal-support in IRC.