User david fullerton - FogBugz Knowledge Exchange

Answer by David Fullerton for CBugEventQuery.SetParamDate ignoring time?

2009-10-01T15:31:08Z

This may be a time zone issue. All dates are stored in the database as UTC, but you're using System.DateTime.Now which could be in another time zone. Try using System.DateTime.UtcNow and see if that gives you different results.

Answer by David Fullerton for Download Plug-ins and updates directly from within FogBugz

2009-09-30T16:58:00Z

This is definitely something we wanted to do, we just didn't get to it before launch.

We have a case open to consider this feature for a future release. Please up-vote this question (not this answer) to show your support for adding this feature.

Answer by David Fullerton for Developer license for FogBugz?

2009-09-16T15:35:37Z

Our FogBugz Developer Wiki says that On Demand customers can contact Fog Creek Customer Support for a free developer license.

If you are using the free Student and Startup Edition, the developer license pack is $20.

Answer by David Fullerton for How do I highlight a row with BugMonkey?

2010-05-03T19:38:19Z

You can't apply most styles to table rows - instead, you have to apply them to the table cells.

var ixBug = $("#Menu_Working_On").html().split(' ')[2];
$("tr[ix='" + ixBug + "']")
    .children('th,td').css('background-color', 'orange');

    .children('th,td').css('border-top', '2px dashed orange')
                      .css('border-bottom', '2px dashed orange');

Answer by David Fullerton for Feature Request - Add subcase button on case detail view

2009-10-26T16:45:51Z

When you edit a case you can add subcases or set the parent case.

Answer by David Fullerton for What do I do when FogBugz tells me, "The transaction log for database 'fogbugz' is full"?

2009-10-19T20:31:37Z

Have you tried changing the transaction log from Full to Simple?

http://stackoverflow.com/questions/996403/disable-transaction-log

How can I add a link to my plugin page in the FogBugz main menu?

2009-10-19T15:42:46Z

I see there are interfaces to add links to the Extras, Admin, and My Settings menus, but I don't see an interface to add a link to the main menu. How can I do this?

Answer by David Fullerton for How can I add a link to my plugin page in the FogBugz main menu?

2009-10-19T15:48:25Z

Currently there is no interface exposed for this. You can do it via JavaScript, but be aware that this is an unsupported access and may break in the future.

This JS adds a link to the right of the "Wiki" menu item at the top:

$(document).ready(function() { $('#Menu_Wiki').after('<span><a class="navlink" href="default.asp?pg=pgPlugin&sPluginId=plugin@example.com">My Plugin</a></span>') });

This JS adds a link to the left of the "Working On" menu item at the top right:

$(document).ready(function() { $('#belowBanner').prepend('<span><a class="navlink" href="default.asp?pg=pgPlugin&sPluginId=plugin@example.com">My Plugin</a></span>') });

This JS adds a link to the right of the "Help" link at the top right:

$(document).ready(function() { $('#Menu_Help').after(' | <span><a class="navlink" href="default.asp?pg=pgPlugin&sPluginId=plugin@example.com"><span class="dotted">My Plugin</span></a></span>') });

Edit

Remember that this is an unsupported access, and Fog Creek makes no guarantees about its support in future versions. We will not, however, ban plugins from the Plugin Gallery or FogBugz On Demand for using this method to add a link to the top menu.

We do plan to add a supported interface for this in a future version.

Addendum

To make the script run on every page in FogBugz, use an interface like IPluginStaticJS to add a static JS file that is included on every page.

Answer by David Fullerton for Are previous versions of FogBugz available for download somewhere?

2009-10-15T15:45:16Z

This is something we haven't quite gotten to yet. For now, send us an email via http://contact.fogcreek.com and include your order information (email / order id) and the version you need to download and we'll send you a link.

Answer by David Fullerton for French locale does not work in Firefox

2009-10-09T20:17:58Z

The language comes from two locations:

The Site Language determines certain site-wide things like category names, statuses, and the language that bug event notifications are stored in
Your Personal Language determines what language the interface appears to you in, since you might have users with different language preferences. By default, your personal language is determined by the language your browser reports. In your case, IE is probably reporting French (France) as your language, but Firefox is reporting English. You can either fix it in the browser, or set it explicitly in FogBugz under My Settings | Options

Answer by David Fullerton for Feature Request for Workflow Plug-in: Universal Status codes.

2009-10-09T14:12:00Z

If you search "status:mystatus", it will return all results with that status regardless of category. So if you have a bug status and a feature status called "mystatus", they will both be returned.

Answer by David Fullerton for CBug.hrsRemainingDescendentSum questions

2009-10-08T18:31:42Z

Looks like a pair of bugs. One, that the documentation is missing, and two, that we don't expose hrsRemaining. It's not something that should be hidden, so you can go ahead an use it.

We calcalate hrsRemaining this way:

double remainingHours = Math.Max(0.0, myBug.hrsCurrEst- myBug.hrsElapsed)

Answer by David Fullerton for Formatting of estimates

2009-10-08T18:25:27Z

There's no way to do this right now, but I've opened a feature request.

Answer by David Fullerton for Under what circumstances is a user not allowed to see another user?

2009-10-05T20:29:08Z

It's pretty rare. Users can see each other if they share read permissions on any projects. So to make users that can't see each other, create a user that only has read permission on one project, and then have another (non-admin) user that cannot read that project.

Answer by David Fullerton for What is the Query for checking Bug Security?

2009-10-05T12:51:31Z

We give you the source code, so it's not exactly a secret :) It looks something like this:

WHERE Bug.ixProject IN (1, 2, 4, 5, 9, 11 .. )

You can generate that list of projects using a CProjectQuery like so:

CProjectQuery query = api.Project.NewProjectQuery()
query.ExcludeUnreadableWithin = true;
int[] ids = query.ListIds();

The unfortunately named ExcludeUnreadableWithin property means "don't include any projects within which I cannot read bugs". If what you're really after is writable, then use the ExcludeUnwritableWithin property.

Edit

These are not to be confused with ExcludeUnreadable and ExcludeUnwritable, which refer to the Project object itself, not Bugs within a project. For example,

Modifying the project name (sProject) requires write permission on the Project because you must be an admin.
Creating a bug in the project requires write permission within the project, not admin permissions

Answer by David Fullerton for Is there a way to set the id element of a control created with Forms.SubmitButton?

2009-10-02T21:01:41Z

All those Forms methods can take a dictionary as the final parameter, which lets you set attributes. In your case you'd do something like this:

Hashtable attrs = new Hashtable();
attrs["id"] = "myid";
retVal.Append(Forms.SubmitButton(api.AddPluginPrefix("btnRefresh"), "Refresh", attrs));

Answer by David Fullerton for How do you set a filter for cases for all but 1 user?

2009-10-01T18:33:14Z

Use a negative search axis. You can add these to any filter by adding "Search for":

-assignedto:"bob"

-project:"foo"

-category:"feature"

-area:"undecided"

Answer by David Fullerton for Change 'My Cases' columns?

2009-09-22T14:48:43Z

You can't change the 'My Cases' filter, but you could load the filter, customize it, and then save your changes by clicking the 'Save Filter' link on the right. Column preferences are saved with a filter, so when you load your saved filter your columns will be restored.

Answer by David Fullerton for What do I use as the P4DTG defect tracking source server address?

2009-09-21T20:55:40Z

That should be correct. I've never seen an error like that before -- it's definitely not one thrown by the FogBugz DTG plugin. Did you install the DTG plugin using setup downloaded from FogBugz? It should try to automatically fill in the URL for you.

Answer by David Fullerton for FogBugz doesn't return site working schedule sometimes

2009-09-18T19:14:39Z

I looked into it, and it looks like a bug on our end. It happens if the specified person has never edited their working schedule. In this case, it should load and return the site working schedule, but that doesn't seem to be happening.

Answer by David Fullerton for How do I create a csv-exporting url with a filter?

2009-09-17T14:52:04Z

As of version 1.2.1, you can append

&P[ixPlugin]_ixFilter=[ixFilter]

to the URL, where ixPlugin is the plugin id (you can get it from the URL that it takes you to when you export a filter), and ixFilter is the filter id (you can get this from the URL of a filter). For example:

http://my.fogbugz.com/default.asp?pg=pgPluginBinary&ixPlugin=1&P1_ixFilter=4

You can also append a search string in version <1.2.1:

&P[ixPlugin]_sSearch=[search]

For example

http://my.fogbugz.com/default.asp?pg=pgPluginBinary&ixPlugin=1&P1_sSearch=assignedto%3a%22me%22

Answer by David Fullerton for Questions button on this site seems broken.

2009-09-14T19:50:09Z

Which tab on the right is highlighted when you click "Questions"? I believe it remembers the tab you last picked, so you might be stuck on "Featured", which has 0 questions.

Answer by David Fullerton for Feature Request: Allow editing case notes for a limited window

2009-09-11T14:53:52Z

One problem with this is that email notifications need to be sent out in a timely manner. You probably don't want your incorrect text to get sent out to everyone subscribed to the case, but you also don't want to wait an hour for people to get the notification. Even waiting 5 minutes can put a damper on the conversation and make you walk down the hall to talk to the person rather than putting the data in FogBugz.

Answer by David Fullerton for How can I monitor the Fogbugz maintenance service?

2009-09-10T17:51:53Z

If you don't mind giving your service database access, you could query

SELECT sValue FROM Setting WHERE sKey = 'dtLastHeartbeat'

If that date/time is greater than a few minutes ago, the maintenance service is not running correctly.

Comment by David Fullerton

2009-10-26T17:03:49Z

What version of FogBugz? There was a bug a couple releases ago where subcases would always inherit their parent case's category, even if you explicitly set a category for them.

Comment by David Fullerton

2009-10-26T17:02:00Z

Currently this isn't possible, but I've opened a case for it

Comment by David Fullerton

2009-10-19T21:58:58Z

I sent you an email to try to debug this further.

Comment by David Fullerton

2009-10-12T15:53:18Z

It does something like "WHERE ixStatus IN (SELECT ixStatus FROM Status WHERE sStatus LIKE '%mystatus%')

Comment by David Fullerton

2009-09-29T13:56:44Z

Are you sure that filter is visible to you? I only see that error if I type in the number for another user's filter that isn't shared.

Comment by David Fullerton

2009-09-21T23:27:20Z

Sorry, the terminology is confusing. There is both a plugin for FogBugz (the "Perforce DTG Integration" plugin), and a plugin for the DTG (the "FogBugz DTG Plugin"). Try reinstalling the latter via FogBugz under Admin > Source Control. If that doesn't work call us (fogcreek.com/contact.html) and set up a time for a technical support call so we can use Copilot to try to figure out what's going on.

Comment by David Fullerton

2009-09-18T19:53:31Z

Yes, that's also possible if you've never edited the site working schedule. We'll get this fixed soon.