Spreadsheet+RequestorDetails
Comments0
833pages on
this wiki
this wiki
Here's a diff to create a Spreadsheets link which includes some requestor details if the user has the rights to see them (Global ACL AdminUsers):
--- /opt/rt3/share/html/Search/Results.tsv 2008-08-30 19:22:14.000000000 -0400
+++ /opt/rt3/local/html/Search/Results.tsv 2009-07-16 15:52:42.000000000 -0400
@@ -73,6 +73,10 @@
Requestors->MemberEmailAddressesAsString Cc->MemberEmailAddressesAsString AdminCc->MemberEmailAddressesAsString
DueObj->ISO ToldObj->ISO CreatedObj->ISO ResolvedObj->ISO LastUpdatedObj->ISO);
+push(@attrs, map {"Requestors->UserMembersObj->First->$_"}
+ qw(RealName HomePhone WorkPhone Address1 Address2 Zip)) if
+ $session{'CurrentUser'}->HasRight(Object => $RT::System, Right => 'AdminUsers');
+
$r->content_type('application/vnd.ms-excel');
while ( my $Ticket = $Tickets->Next()) {
my $row;
@@ -106,6 +110,7 @@
my $label = $attr;
$label =~ s'Obj-.(?:AsString|Name|ISO)''g;
$label =~ s'-\>MemberEmailAddressesAsString''g;
+ $label =~ s'Requestors-\>UserMembersObj-\>First-\>''g;
push @header, $label;
}
foreach my $id (sort keys %known_cfs) {