Tagged Questions

1
vote
1answer
86 views

Filter using AND OR Not Equal to etc.

I'd like to filter my cases for all milestones except version 1.1. Is there a way to do this? Thanks
5
votes
1answer
441 views

Very long running MySQL queries [closed]

We experienced some very long running SQL queries on MySQL 5.5 server: DELETE FROM IndexFilePage WHERE ixIndexFile IN (SELECT ixIndexFile FROM IndexFile WHERE ixLastGeneration &lt …
4
votes
5answers
419 views

What kind of search queries can I perform in FogBugz?

What is FogBugz search capable of?
3
votes
1answer
303 views

Can I run direct SQL queries against my FogBugz On Demand database?

Can I select, insert, update and delete against my database?
1
vote
1answer
64 views

Stastical Calculations

How can I get Statistical Calcualtions on data from FogBugz? For example, how do I get the average time spent by a developer on solving bugs of priority-2 during last one month.
0
votes
2answers
363 views

feature request: quick drilldown icon for projects

I'm looking at my main screen, and see cases in foo ... cases in bar ... I would like to see a little drill-down icon next to each of the "cases in..." such that clickin …
1
vote
1answer
82 views

Is there a way to order results by an aggregate function using the CSelectQuery API?

The syntax checker of the CSelectQuery API is making things a little difficult for me today. I am trying to run an aggregate query to get a count of bugs for each category listed …
1
vote
1answer
81 views

Listing bugs is slow with plugin bug table join.

When I have my plugin join with the bug table (using the IPluginBugJoin interface), it takes a very long time to list cases (usually a couple minutes), especially if the search fil …