[rt-users] How do I view my custom fields in my ticket query result?

[soma]

That worked. Thanks Kenn.

Soma Manjulavil,
Boncle Inc.

Get a free BoncleExpress from http://www.boncle.com
The assurance of secure messages and transactions


-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker at lbl.gov] 
Sent: Friday, September 21, 2007 11:23 AM
To: soma
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] How do I view my custom fields in my ticket query
result?

Soma,


	You need to go to the "Advanced" query screen. There, you find where

the code (bottom box) is displaying the fields and add this

                  '__CustomField.{xxxxxxxxx}__',

where xxxxxxxxxis the name of the custom field. It is case-sensitive so 
do not forget the capitols in the name. Put this where you want it to 
show in your query and that should do it.


Kenn
LBNL

On 9/21/2007 10:54 AM, soma wrote:
> Hi,
> 
>  
> 
>     We have RT 3.6.4 installed. I was trying to create a query which 
> shows all the tickets assigned to a specific person. Query is working 
> fine. It returns all the rows. My problem is that I am not able to add 
> the custom fields into my display field list. Custom fields are not 
> showing-up in the "Display Columns->Add Columns" list box. How can I fix 
> this? I need to view the custom fields in my query result.  Any help 
> would be appreciated.
> 
>  
> 
> Soma Manjulavil,
> 
> Boncle Inc.
> 
>  
> 
> Get a free BoncleExpress from http://www.boncle.com 
> <BLOCKED::http://www.boncle.com>
> 
> The assurance of secure messages and transactions
> 
>  
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com