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

[Kenneth Crocker]

Matt,


	Let me see the query (copy from your advanced screen). Are you sure the 
tickets that are a result from the query have something in that CF? Are 
you getting everything else you selected in the query?


Kenn
LBNL

On 9/24/2007 8:20 AM, matt wells wrote:
> I have the same issue and do what you suggested but my fields come back 
> in the query blank.  When I go in the ticket I can see the custom fields 
> though and modify them..
> 
> On 9/21/07, * soma* <soma at boncle.com <mailto:soma at boncle.com>> wrote:
> 
>     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
>     <mailto:KFCrocker at lbl.gov>]
>     Sent: Friday, September 21, 2007 11:23 AM
>     To: soma
>     Cc: rt-users at lists.bestpractical.com
>     <mailto: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
>     <mailto:sales at bestpractical.com>
>      >
>      >
>      > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>      > Buy a copy at http://rtbook.bestpractical.com
>     <http://rtbook.bestpractical.com>
> 
> 
>     _______________________________________________
>     http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
>     Community help: http://wiki.bestpractical.com
>     Commercial support: sales at bestpractical.com
>     <mailto:sales at bestpractical.com>
> 
> 
>     Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>     Buy a copy at http://rtbook.bestpractical.com
> 
>