select count(id) as openissues from issues where statusname = 'Open' select created, id, name, publicid, projectidfk from issues where statusname = 'Open' order by created desc select created, id, name, publicid, projectidfk from issues where statusname = 'Open' order by created asc select created, id, name, publicid, projectidfk, duedate from issues where duedate is not null and duedate < and statusname = 'Open' order by created asc select count(id) as numissues, projectname, projectidfk from issues where statusname = 'Open' group by projectidfk, projectname

Project Stats

Issues assigned to #session.userbean.getName()#

	#openissues.openissues#0 Open \| #issues.recordCount# Total
Project	Open Issues
#projectname#	#numissues# open
Newest:	#mostrecent.publicid#) #mostrecent.name# #dateFormat(mostrecent.created, "ddd, mmm d")# #timeFormat(mostrecent.created, "h:mm tt")#
Oldest:	#oldest.publicid#) #oldest.name# #dateFormat(oldest.created, "ddd, mmm d")# #timeFormat(oldest.created, "h:mm tt")#
Over Due:	#overdue.publicid#) #overdue.name# Due: #dateFormat(overdue.duedate, "ddd, mmm d")#

To Begin

Welcome to Lighthouse Pro, a web based bug and issue tracker. To begin using Lighthouse Pro, simply select from one of the projects in the left hand menu. You may update your preferences or logout from the left hand menu as well.

This is version #application.version# of Lighthouse Pro. The latest version can be found at http://lighthousepro.riaforge.org. It was created by Raymond Camden.

Announcements

#project#

#title#

#paragraphFormat(body)#

#dateFormat(posted, "dddd mmm d")# #timeFormat(posted, "h:mm tt")# - #author#

There are no announcements at this time.