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