[rt-users] Getting the total record count

[Rick Measham]

> 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
thing!

> 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>