Spreadsheet+RequestorDetails

From Request Tracker Wiki
Revision as of 16:37, 6 April 2016 by Admin (talk | contribs) (2 revisions imported)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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) {