5
votes
1answer
287 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 < …
3
votes
5answers
270 views
What kind of search queries can I perform in FogBugz?
What is FogBugz search capable of?
1
vote
1answer
30 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.
1
vote
1answer
65 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 …
0
votes
2answers
295 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
52 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 …
2
votes
1answer
183 views
Can I run direct SQL queries against my FogBugz On Demand database?
Can I select, insert, update and delete against my database?