Welcome to the FogBugz Knowledge Exchange

Question

1

For a project which has an incoming mailbox assigned to it, there is a "check statistics" page linked from the edit project page. It provides a summary of incoming email counts.

Is there anything we can do to see a list of the incoming and outgoing emails for any given project?

I know the incoming emails are turned into cases. What I would like to see is a list of any emails sent out based on interaction with the cases. An overall summary, ability to get it at the project level, and naturally a drill down in to the email to see the details sent. Capability to resend it might be nice too since I normally am looking into something for one of our customers based on an inquiry.

Possibly a plug-in?

Rick Schummer

edited Jul 15 2010 at 17:39

adambox♦♦
20.8k●14●46

asked Jan 12 2010 at 16:33

Rick Schummer
60●6

Hi Rick, where is this summary found? – Justine Jan 12 2010 at 17:38

If you edit a project you should have a "check statistics" link on the project page. It is a hyperlink to the statistics. – Rick Schummer Jan 14 2010 at 16:33

Hi Rick, yep I understood what you said the first time ;) but ... could you please describe exactly where is this link? When I edit a project in FB7, there's no hyperlink called "check statistics". This text string doesn't appear anywhere on the page. It's also not found under the "Reports" menu. It's not on the Edit Mailbox page either. Is it possible this is something only the Hosted FB people see? Thanks for your help. I'd love to see the stats. Cheers, Justine – Justine Mar 17 2010 at 17:11

1

Hi Justine - it appears you have to have an email assigned to the project specifically. Projects that do not have an email assigned to them do not have this hyperlink. So you need to go to the email list and assign to project first. – Rick Schummer Mar 19 2010 at 21:08

adambox · Accepted Answer · 2010-01-15 21:29:10Z UTC

You could definitely make a plugin to provide this functionality. Plugins can perform generic queries on the database as well as access FogBugz objects through queries.

What you would need to do is build an interface that allows the user to specify a project, then simply run some SQL queries to get all the BugEvents which are emails.

You could get all incoming email bugevents:

SELECT * FROM BugEvent WHERE fEmail = 1

Or outgoing emails:

SELECT * FROM BugEvent WHERE sVerb = 'Replied' OR sVerb = 'Emailed'

or use an entity query, CBugEventQuery which will return objects instead of rows, making other operations easier.

Check out the FogBugz DB Schema, and the Plugin Architecture documentation.

Way to track emails incoming and outgoing

1 Answer