Queries to Count items in Categories/ sub Categories

Topics: Customizing BugNET
Aug 29, 2012 at 10:34 PM
Edited Aug 29, 2012 at 10:41 PM
Is it possible in BugNet to run queries(Report) that can return the number of items in a certain category- Assuming date range is giving? End of every month, we want to be able run a report to know how tickets were recorded per each category/Sub. (Report Stats)
Thanks,
Developer
Sep 6, 2012 at 1:59 PM

The queries feature does not support aggregates so not out of the box.

It would have to be custom code within BugNET or you could query the database directly using the BugNet_IssuesView (View) as your source.  This is the prefered way to get at Issue data since it has support for some extra "calculated" columns like if the issue is closed (based on issue types that are flaged as "is closed").