https://rt-wiki.bestpractical.com/index.php?title=Spreadsheet%2BRequestorDetails&feed=atom&action=history
Spreadsheet+RequestorDetails - Revision history
2024-03-28T10:47:55Z
Revision history for this page on the wiki
MediaWiki 1.37.2
https://rt-wiki.bestpractical.com/index.php?title=Spreadsheet%2BRequestorDetails&diff=3699&oldid=prev
Admin: 2 revisions imported
2016-04-06T20:37:47Z
<p>2 revisions imported</p>
<p><b>New page</b></p><div>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]]):<br />
<br />
<nowiki>--- /opt/rt3/share/html/Search/Results.tsv 2008-08-30 19:22:14.000000000 -0400<br />
+++ /opt/rt3/local/html/Search/Results.tsv 2009-07-16 15:52:42.000000000 -0400<br />
@@ -73,6 +73,10 @@<br />
Requestors-&gt;MemberEmailAddressesAsString Cc-&gt;MemberEmailAddressesAsString AdminCc-&gt;MemberEmailAddressesAsString<br />
DueObj-&gt;ISO ToldObj-&gt;ISO CreatedObj-&gt;ISO ResolvedObj-&gt;ISO LastUpdatedObj-&gt;ISO);<br />
<br />
+push(@attrs, map {"Requestors-&gt;UserMembersObj-&gt;First-&gt;$_"}<br />
+ qw(RealName HomePhone WorkPhone Address1 Address2 Zip)) if<br />
+ $session{'CurrentUser'}-&gt;HasRight(Object =&gt; $RT::System, Right =&gt; 'AdminUsers');<br />
+<br />
$r-&gt;content_type('application/vnd.ms-excel');<br />
while ( my $Ticket = $Tickets-&gt;Next()) {<br />
my $row;<br />
@@ -106,6 +110,7 @@<br />
my $label = $attr;<br />
$label =~ s'Obj-.(?:AsString|Name|ISO)''g;<br />
$label =~ s'-\&gt;MemberEmailAddressesAsString''g;<br />
+ $label =~ s'Requestors-\&gt;UserMembersObj-\&gt;First-\&gt;''g;<br />
push @header, $label;<br />
}<br />
foreach my $id (sort keys %known_cfs) {<br />
</nowiki></div>
Admin