[rt-users] Downloading query results to spreadsheet

[Kenneth Crocker]

Stephen,


	I have no idea what you just said. What's a regex? How did RT handle 
parent/child displays when it downloaded to a spreadsheet in the first 
place? Why would that change?

Kenn
LBNL

On 2/20/2008 1:42 PM, Stephen Turner wrote:
> At Wednesday 2/20/2008 04:25 PM, Kenneth Crocker wrote:
>> Stephen,
>>
>>         HA! I got it working. I had failed to copy & modify the 
>> "ScrubHTML" fiel. The titles line up with the data fine now. The only 
>> problem I have now is that the ticket link data doesn't display 
>> correctly. I get subject, dates, status, etc. OK. For Parent/Child or 
>> DependsOn/DependedOnBy I get this:
>>         "<a href=", 
>> https://rt.dev.lbl.gov/Ticket/Display.html?id=55009, ">, 55009, 
>> </a><br />".
>>
>>         Any clue about that result? Anyone?
>>
>> Kenn
>> LBNL
> 
> I'd say you've found a bug. It's because   
> /Elements/RT__Ticket/ColumnMap wraps the <href> tag around link field 
> values.
> 
> A kludge that might work is to strip out the HTML tag from the result, a 
> bit like the way the <br> tag is stripped out:
> 
> $row->{ $column } =~ s/, <br>//g;
> 
> You'd need a regex that would strip off everything around the '55009' 
> from  '<a href=", https://rt.dev.lbl.gov/Ticket/Display.html?id=55009, 
> ">, 55009, </a><br />'
> 
> Steve
> 
>