Count and Group By CF
Barton Chittenden <[email protected]> Fri, 9 Dec 2016 12:23:12 -0500
| Newsgroups | gmane.comp.bug-tracking.request-tracker.user |
|---|---|
| Message-ID | <CAMSJbVtbVY-4F27e8PQ8U2RZi+ggXuypEOi_mkiZ4NkGGwZ3GA@mail.gmail.com> |
We use a CF called 'Community Bug' to track bugzilla bug numbers associated
with customer tickets. It would be really useful to know which values of
CF.{Community Bug} occur most often.
If you'll pardon a mix of SQL and query builder syntax, I'm looking to do
something like this:
SELECT COUNT(*), CF.{Community Bug}
FROM CF
GROUP BY CF.{Community Bug}
ORDER BY COUNT(*)
I'm well aware that query builder doesn't work like this, but I'm wondering
if there's a way to do something like this.
I'm sure that I could do this by querying the database directly, but I'd
prefer to do it the RT way if there is one.
Thanks!
--Barton
---------
RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training
* Los Angeles - January 9-11 2017