I have gone through and added extra columns to the spreadsheet by just updating
/share/html/Search/Results.tsv. It took some testing to get the right fields
down but it was a simple edit. This is what I currently have:
my @attrs = qw( id QueueObj->Name Subject Status TimeEstimated TimeWorked
TimeLeft Priority FinalPriority OwnerObj->Name OwnerObj->RealName
Requestors->UserMembersObj->First->RealName
Requestors->UserMembersObj->First->Organization
Requestors->UserMembersObj->First->Address1
Requestors->MemberEmailAddressesAsString
Cc->MemberEmailAddressesAsString AdminCc->MemberEmailAddressesAsString
DueObj->ISO ToldObj->ISO CreatedObj->ISO ResolvedObj->ISO
LastUpdatedObj->ISO);
From: [email protected]
[mailto:[email protected]] On Behalf Of
[email protected]
Sent: Wednesday, June 24, 2009 6:55 AM
To: [email protected]
Subject: [rt-users] Customize spreadsheet output?
Hello,
I want to use the spreadsheet export with the same columns as those displayed
in the query web result.
The solution described here
(http://wiki.bestpractical.com/index.cgi?SpreadsheetDisplayedFields) is not
working with RT 3.8.*
Does someone have already done a working patch for RT 3.8 ?
Thanks
******************************************************************
PLEASE NOTE: This e-mail and any attachments hereto are
confidential, and may contain proprietary, privileged or legally
protected information.
If you are not the intended recipient, please delete this email
and all attachments without making copies and notify the sender
by telephone or e-mail.
E-mail transmissions are inherently subject to disruption,
corruption, late or incomplete delivery, and viruses.
The sender does not accept responsibility for any errors,
omissions or other consequences resulting from the transmission
of this e-mail.
This notice applies to all TerpSys e-mails and attachments
appearing in all e-mail strings containing the message to which
this notice is appended._______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [email protected]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com