[rt-users] Downloading query results to spreadsheet

[Kenneth Crocker]

Stephen,

	thanks. I'm definitely going to look at it. I had modified the default 
set of columns in my local directory for this very purpose. It seems a 
waste of time to have to delete any unwanted columns one at a time and 
then to have them show up anyway in a downloaded result. Oh well, that's 
why we have the user group, huh?


Kenn
LBNL

On 2/19/2008 6:46 AM, Stephen Turner wrote:
> At Friday 2/15/2008 05:55 PM, Kenneth Crocker wrote:
>> To all,
>>
>>         I have just upgraded to 3.6.4 and am having some difficulty 
>> getting the
>> results of a query into a spreadsheet with the fields I selected for the
>> query. Instead, I get all sorts of tickets fields I did NOT select and
>> am missing several that I DID select. Why does RT seem to ignore the
>> fields I am/not selecting for the query when it downloads the results to
>> excel? Anyone?
>>
>> Kenn
>> LBNL
> 
> Kenn,
> 
> That's the way the spreadsheet feature works (and always has, I think) - 
> it's intended to give you a full set of fields for each ticket. There's 
> a contrib on the wiki that downloads only the fields you see on the 
> results screen:
> 
> http://wiki.bestpractical.com/view/SpreadsheetDisplayedFields
> 
> Good luck,
> Steve
>