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.
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
LBNLOn 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.
Get a free BoncleExpress from http://www.boncle.com
The assurance of secure messages and transactionsFrom: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Friday, September 21, 2007 11:23 AM
To: soma
Cc: rt-users@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.
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@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@lbl.gov]
Sent: Friday, September 21, 2007 11:23 AM
To: soma
Cc: rt-users@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.
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
LBNLOn 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…
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@lbl.gov
<mailto:KFCrocker@lbl.gov>]
Sent: Friday, September 21, 2007 11:23 AM
To: soma
Cc: rt-users@lists.bestpractical.com
<mailto:rt-users@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@bestpractical.com
<mailto:sales@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@bestpractical.com
<mailto:sales@bestpractical.com>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
This gives us the output as we search on the custom field ‘DOGS’ perfectly
but as you can see we’ve added the colum ‘Rover’.
That fields shows on the search but is empty. When I click on the ticket I
can see the CF and even edit it.
I can also search on that field and will come back perfect based on that
field. It just won’t show me the entries in that field on my search.
The CF is a Select one value
Queue = ‘OUR-QUEUE’ AND Created > ‘Feb 28, 2007’ AND Created < ‘April 1,
2007’ AND ‘DOGS.{BREED}’ LIKE ‘LAB’
I see two potential problems with your query, that is if the E_mail I
got is showing properly what you have:
1) it looks likes the blank line you have (after '_NEWLINE_') shows one
double quote. It should be two single quotes with a blank space between.
It may just be what I’m seeing in the E_mail.
2) the other is that your last line has a coma at the end. It shouldn’t
be there. The last line should end with a single quote. That’s it.
I don’t know it that helps but check it out.
Kenn
LBNLOn 9/24/2007 9:47 AM, matt wells wrote:
This gives us the output as we search on the custom field ‘DOGS’
perfectly but as you can see we’ve added the colum ‘Rover’.
That fields shows on the search but is empty. When I click on the
ticket I can see the CF and even edit it.
I can also search on that field and will come back perfect based on that
field. It just won’t show me the entries in that field on my search.
The CF is a
/Select one value/
Queue = ‘OUR-QUEUE’ AND Created > ‘Feb 28, 2007’ AND Created < ‘April 1,
2007’ AND ‘DOGS.{BREED}’ LIKE ‘LAB’
Matt,
You should mention the custom field in the top portion of the query. That
is what I did for my query & it is working.
Eg:-
Queue = ‘OUR-QUEUE’ AND Created > ‘Feb 28, 2007’ AND Created < 'April 1,
I see two potential problems with your query, that is if the E_mail
I
got is showing properly what you have:
1) it looks likes the blank line you have (after '_NEWLINE_') shows
one
double quote. It should be two single quotes with a blank space between.
It may just be what I’m seeing in the E_mail.
2) the other is that your last line has a coma at the end. It
shouldn’t
be there. The last line should end with a single quote. That’s it.
I don’t know it that helps but check it out.