Recent issues block

epr - May 9, 2005 - 06:58
Project:Project issue tracking
Version:6.x-1.x-dev
Component:Views integration
Category:feature request
Priority:normal
Assigned:mfb
Status:closed
Issue tags:download & extend, drupal.org redesign
Description

It would be nice to have a block with recently added/modified issues.
Like recent forum topics, but then for issues.

Ewout

#1

leafish_paul - October 11, 2005 - 12:29

Here, have a quick custom block:

<?php
   
// Displays the ten most recently changed critical issues
   
$sql = "SELECT n.nid, n.title FROM node n INNER JOIN project_issues pi ON pi.nid=n.nid INNER JOIN project_issue_state pis ON pi.sid=pis.sid";
   
$sql .= " WHERE pi.priority=1 AND pis.name IN ('active', 'needs work', 'testers needed') ORDER BY n.changed DESC LIMIT 10";
   
$result = db_query(db_rewrite_sql($sql));
    while (
$issue = db_fetch_object($result)) {
       
$items[] = l( $issue->title, 'node/'.$issue->nid);
    }
    return
theme('item_list', $items);
?>

Any thoughts on having a similar, configurable block in the module itself? It could be a nice little feature,

#2

aclight - April 13, 2008 - 03:11
Project:Project» Project issue tracking
Version:x.y.z» 5.x-2.x-dev
Status:active» postponed

Once #76725: Refactor project issue module to use Views gets finished, this shouldn't be difficult to do at all, and could be provided as a default block view in the project issue tracking module. I'm moving this into the right queue and marking as postponed.

#3

dww - February 25, 2009 - 12:34
Version:5.x-2.x-dev» 6.x-1.x-dev
Component:User interface» Views integration
Status:postponed» active

Indeed, this would be a trivial view.

#4

dww - February 25, 2009 - 12:35

Oh, and they want this for the redesign...

#5

mfb - April 8, 2009 - 21:06
Assigned to:Anonymous» mfb

#6

mfb - April 8, 2009 - 22:49
Status:active» needs review

add block display for existing project_issue_project view.

AttachmentSize
project_issue-recent-issues2.patch 4.91 KB

#7

dww - April 9, 2009 - 00:07
Status:needs review» fixed

Cleaned this up a bit, tested, and committed to HEAD:

http://drupal.org/cvs?commit=194756

Note that I ripped out a bunch of the junk that views includes by default in the exported views, e.g. data about argument validator plugins we're not even using, etc. I also changed the default title of this block to just "Recent issues" since I think that makes a lot more sense.

See also #428396: Project node views argument validator generates SQL error for numeric project nids.

Thanks!
-Derek

#8

dww - April 9, 2009 - 18:35

I wanted to add a filter to this so it only shows open issues. That led me to discover and fix #429190: "Special" project issue views filters only work for exposed filters. ;) So, I just committed a change to this default view to add a (working) non-exposed filter on open issues. ;)

#9

System Message - April 23, 2009 - 18:40
Status:fixed» closed

Automatically closed -- issue fixed for 2 weeks with no activity.

#10

dww - April 23, 2009 - 19:46
Status:closed» needs work
Issue tags:+needs drupal.org deployment

Forgot to mark that we need to deploy this on d.o:
- deploy the code
- clear views cache
- enable/place/configure the block

#11

dww - May 5, 2009 - 19:44
Status:needs work» fixed
Issue tags:-needs drupal.org deployment

now deployed on d.o.

#12

System Message - May 19, 2009 - 19:50
Status:fixed» closed

Automatically closed -- issue fixed for 2 weeks with no activity.

 
 

Drupal is a registered trademark of Dries Buytaert.