[rt-users] Spreadsheet view displays more columns than in search

[Flynn, Timothy J]

Eric,

That's the weird part.  It is the same exact query.  They perform the
search and see the web results, then they click the spreadsheet link and
it comes up different than what is in the web results.  I haven't
applied the patch yet.  Will that fix it?

Thanks,
-Tim
 

-----Original Message-----
From: Schultz, Eric [mailto:ESchultz at corp.untd.com] 
Sent: Tuesday, May 23, 2006 3:57 PM
To: Flynn, Timothy J; rt-users at lists.bestpractical.com
Subject: RE: [rt-users] Spreadsheet view displays more columns than in
search 

Only thing I can think of is that you somehow modified the query before
doing one query vs. the other?  Maybe using the browser navigation vs.
the application navigation?  If the spreadsheet had more, I would say it
could be something with that query being less restrictive, but that's
not the case.

> Thanks Eric,  do you know why I'd be getting different results in
> spreadsheet vs the web list?  On one report I am getting 14 tickets in
> the web view and in the spreadsheet I am getting 11 and the data is
> wrong..  FYI the web results are correct and the spreadsheet 
> is not.  Is
> something not being escaped that is affecting the query?
> 
> -Tim
>  
> 
> -----Original Message-----
> From: Schultz, Eric [mailto:ESchultz at corp.untd.com] 
> Sent: Tuesday, May 23, 2006 3:32 PM
> To: Flynn, Timothy J; rt-users at lists.bestpractical.com
> Subject: RE: [rt-users] Spreadsheet view displays more columns than in
> search 
> 
> 
> > When my users are searching for tickets, they select the 
> columns they
> > want and then search.  A lot of them like the spreadsheet 
> view so they
> > can make reports.  One problem is in the spreadsheet view 
> there are a
> > lot of extra columns that they didn't add.  They appear to 
> be most of
> > the default time fields in RT (IE, told date, due date, etc). 
> >  Is there
> > a way to omit these?
> > 
> > RT 3.4.5
> 
> This is what you want:
> http://wiki.bestpractical.com/index.cgi?SpreadsheetDisplayedFields
> It was vandalized, so I reverted to the previous saved version.
> 
> Eric Schultz
> United Online
>