Count and Group By CF

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

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.

What RT are you using?

In 4.2 the defaults will get you mostly there.

Search → Chart

Group by → Custom field

Choose CF, then “Update Chart”

-m