[rt-users] Getting the total record count

Rick Measham rickm at 3d3.com
Wed Jan 19 18:11:47 EST 2005

> On Wed, 19 Jan 2005 17:54:42 +1100, Rick Measham <rickm at 3d3.com> wrote:
> > On the Summary (Home) page, I've changed the MyRequests to show the ten
> > OLDEST unowned requests, as these need to be dealt with first.
> > 
> > However this has now led to the predictable question: How do we know how
> > many there are altogether?
> > 
> > I know the users can click the title of the area to get a full list of
> > open tickets, but I'd prefer to put it in the title. Is there a quick
> > way to get the total?

> On Thu, 2005-01-20 at 07:12, Andy Harrison replied:
> Clicking on the "10 newest unowned tickets..." link isn't showing you
> a list of open tickets, it's showing you a list of unowned New or Open
> tickets.

Sorry .. my bad .. I knew what it was showing, just wrut the wrong

> Keep it simple.  While it's not all that difficult to produce a count,
> it's a bad idea because it's going to have to run the whole query
> every single time the home page is displayed.

Yeah .. but I wasn't sure if the final query was run with a limit or if
it only returned the requested number and the total number was available
somewhere else.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20050120/49660087/attachment.sig>

More information about the rt-users mailing list