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?
Cheers!
Rick
signature.asc (189 Bytes)
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?
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.
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.
Andy Harrison
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.
signature.asc (189 Bytes)