FogBugz Technical Support

A forum for technical support discussion related to Fogbugz.
The current FogBugz Knowledge Base can be found at

Posts by Fog Creek Employees are marked:

Release Notes
Network Status

Users seeing their own bugs.

I was really hoping our users would be able to see their own bugs in FogBugz 6. 

Yes, if they enter a bug through the website, they get a ticket.  But if they lose it, I have to look it up in the database.  If a user other than the one that entered the bug wants to see it, they cannot, and if the bug was submitted via e-mail, no one can see it.  At a minimum, I should be able to generate a ticket to give people (I've tried adding one manually to the SQL database tables, this does not work).

What I want is a group of users to see a list of items.

I love the wiki, but am very disappointed this area of the software was not improved at all from version 5.  What good is opening a wiki or discussion group if users cannot see the bugs?  I can link to any bug in my wiki, and people clicking on it get redirect back to the home page.

I am probably going to write a front end that by works directly against the SQL database to get around this issue.  I really think I should not need to do this.
Brad Bellomo Send private email
Monday, September 17, 2007
We wrote our own PHP page to support this:

Look at the "Support Case Lookup". Here is the relevant PHP:

                    $bShowLookup = true;
                    if (strlen($_REQUEST['case_lookup']))
                        $email = $_REQUEST['case_lookup'];
                        if(eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", $email) && strlen($email) < 140 && strstr($email, '') == false)
                            $dbConnect = WebIS_Bugz_DBConnect();
                            $email = quote_smart('%'.$email.'%');
                            $sql = "select sTicket, sTitle, sStatus from wis_fogbugz.bug b, wis_fogbugz.Status s where sCustomerEmail like $email and b.ixStatus = s.ixStatus order by ixBug DESC";
                            $result = mysql_query($sql, $dbConnect);

                            if (mysql_num_rows($result) > 0)
                                while ($line = mysql_fetch_assoc ($result))
                                    echo 'Case: <A HREF="'; . $line['sTicket'] . '">' . $line['sTitle'] . '/' . $line['sTicket'] .'</A>&nbsp;&nbsp;&nbsp;Status: '. $line['sStatus'].'<BR>';
                                $bShowLookup = false;
                                echo 'No Cases Found. Please try another email address.<BR>';
                            echo 'The email address is not in the correct format.<BR>';
                    if ($bShowLookup)
                        echo 'Email Address: <INPUT TYPE="TEXT" SIZE="60" MAXSIZE="150" NAME="case_lookup"> <INPUT TYPE="SUBMIT" VALUE="Lookup">';
Alex Kac Send private email
Tuesday, September 18, 2007
Yes, this works if the bug has a ticket and it is assigned to the user.  It is good, and would save us a step if we let users have access to fogbugz(we haven't yet, for this reason).  If a bug is submitted without a ticket (such as by e-mail) everyone is out of luck.

I wrote an ASP.NET page to display bugs that meet a specific criteria.  This works, as long as I change the SQL query ever time the criteria for viewing bugs changes.

I suspect lots of us are adding similar functionality.
Brad Bellomo Send private email
Tuesday, September 18, 2007

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
Powered by FogBugz Bug Tracking and Evidence-Based Scheduling.