Spreadsheet+RequestorDetails
Jump to navigation
Jump to search
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) {