Many Columns

The following 90 standard and derived fields can be viewed and extracted with CaseDetective. Up to 63 fields can be viewed and extracted at once.

All columns can be sorted by clicking the column header, and all but a few (Working interval columns) can be used as part of a multi-column sort, including reverse sort.

Column	Description	Multi-Sort
Case	The unique Case number.
Category	Bug, Feature, Inquiry etc (includes custom Categories).
Title	The Case's full title.
Status	Active, Resolved (Responded), Resolved (Fixed) etc.
Open?	Yes / No.
Assigned To	Who the case is currently assigned to.
Priority	1 - Must Fix, 4 - Fix If Time (or whatever you've set in FogBugz for each priority).
Priority Name	Must Fix,Fix If Time (or whatever you've set in FogBugz for each priority).
Priority ID	Unique Priority number.
Project	Project's name.
Project Owner	Project's default user.
Area	Area name.
Release	Release, including date as shown in FogBugz.
Release Name	Release name without date as shown in FogBugz.
Release Date	Date set for Release.
Time Until Release	Time in days and hours until release due.
Time Until Release - Hrs	Time in hours until release due.
Time Until Release (Working)	Time in working days and hours until release due.
Time Until Release (Working) - Hrs	Time in working hours until release due.
Due	Date and time case is due.
Date Due	Date case is due.
Time Due	Time of day case is due.
Time Until Due	Days and hours until case is due.
Time Until Due - Hrs	Hours until case is due.
Time Until Due (Working)	Working days and hours until case is due.
Time Until Due (Working) - Hrs	Working hours until case is due.
Re-Occurrences	Number of times a bug has been re-submitted via bugzScout.
Orig Estimate	Originally estimated fix time for case.
Orig Estimate - Hrs	Originally estimated fix time for case in hours.
Curr Estimate	Current estimated fix time for case.
Curr Estimate - Hrs	Current estimated fix time for case in hours.
Elapsed	Elapsed time to fix case.
Elapsed - Hrs	Elapsed time to fix case in hours.
Remaining	Remaining time to fix case (Current Estimate - Elapsed).
Remaining - Hrs	Remaining time to fix case (Current Estimate - Elapsed) in hours.
Correspondent	Email address of correspondent.
Customer Type	Client or Department?
Client	Client name for case's project.
Department	Department name for case's project.
Opened	Date and time case opened.
Date Opened	Date case opened.
Time Opened	Time of day case opened.
Time Since Opened	Days and hours since case opened.
Time Since Opened - Hrs	Hours since case opened.
Time Since Opened (Working)	Working days and hours since case opened.
Time Since Opened (Working) - Hrs	Working hours since case opened.
Opened By	FogBugz user the case was opened by.
Resolved	Date and time case resolved.
Date Resolved	Date case resolved.
Time Resolved	Time of day case resolved.
Time Since Resolved	Days and hours since case resolved.
Time Since Resolved - Hrs	Hours since case resolved.
Time Since Resolved (Working)	Working days and hours since case resolved.
Time Since Resolved (Working) - Hrs	Working hours since case resolved.
Resolved By	FogBugz user the case was resolved by.
Closed	Date and time case closed.
Date Closed	Date case closed.
Time Closed	Time of day case closed.
Time Since Closed	Days and hours since case closed.
Time Since Closed - Hrs	Hours since case closed.
Time Since Closed (Working)	Working days and hours since case closed.
Time Since Closed (Working) - Hrs	Working hours since case closed.
Closed By	FogBugz user the case was closed by.
Last Updated	Date and time case last updated.
Date Last Updated	Date case last updated.
Time Last Updated	Time of day case last updated.
Time Since Last Updated	Days and hours since case last updated.
Time Since Last Updated - Hrs	Hours since case last updated.
Time Since Last Updated (Working)	Working days and hours since case last updated.
Time Since Last Updated (Working) - Hrs	Working hours since case last updated.
Last Updated By	FogBugz user the case was last updated by.
Opened To Resolved	Days and hours between case being opened and resolved.
Opened To Resolved - Hrs	Hours between case being opened and resolved.
Opened To Resolved (grouped)	Weeks, days and hours between case being opened and resolved grouped by hours, days or weeks.
Opened To Resolved (Working)	Working days and hours between case being opened and resolved.
Opened To Resolved (Working) - Hrs	Working hours between case being opened and resolved.
Resolved To Closed	Days and hours between case being resolved and closed.
Resolved To Closed - Hrs	Hours between case being resolved and closed.
Resolved To Closed (Grouped)	Weeks, days and hours between case being resolved and closed grouped by hours, days and weeks.
Resolved To Closed (Working)	Working days and hours between case being resolved and closed.
Resolved To Closed (Working) - Hrs	Working hours between case being resolved and closed.
Opened To Closed	Days and hours between case being opened and closed.
Opened To Closed - Hrs	Hours between case being opened and closed.
Opened To Closed (Grouped)	Weeks, days and hours between case being opened and closed grouped by hours, days and weeks.
Opened To Closed (Working)	Working days and hours between case being opened and closed.
Opened To Closed (Working) - Hrs	Working hours between case being opened and closed.
Ticket	Ticket ID assigned to customer inquiries.
Release Notes	Release notes entered for resolved or closed case.
Version	User defined field, defaults to "Version".
Computer	User defined field, defaults to "Computer".