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

[soma]

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, 
> 2007' AND 'DOGS.{BREED}' LIKE 'LAB'
> 
> '   <b><a href="/Ticket/Display.html?id=__id__">__id__</a></b>/TITLE:#',
> '<b><a 
> href="/Ticket/Display.html?id=__id__">__Subject__</a></b>/TITLE:Subject',
> '__Status__',
> '__QueueName__',
> '__OwnerName__',
> '__Priority__',
> '__CustomField.{Rover}__',
> '__NEWLINE__',
> '',
> '<small>__Requestors__</small>',
> '<small>__CreatedRelative__</small>',
> '<small>__ToldRelative__</small>',
> '<small>__LastUpdatedRelative__</small>',
> '<small>__TimeLeft__</small>'

Soma Manjulavil,
Boncle Inc.
 
Get a free BoncleExpress from http://www.boncle.com
The assurance of secure messages and transactions



-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Kenneth
Crocker
Sent: Monday, September 24, 2007 10:27 AM
To: matt wells
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] How do I view my custom fields in my ticket
queryresult?

Matt,


	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
LBNL

On 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'
> 
> '   <b><a href="/Ticket/Display.html?id=__id__">__id__</a></b>/TITLE:#',
> '<b><a 
> href="/Ticket/Display.html?id=__id__">__Subject__</a></b>/TITLE:Subject',
> '__Status__',
> '__QueueName__',
> '__OwnerName__',
> '__Priority__',
> '__NEWLINE__',
> '',
> '<small>__Requestors__</small>',
> '<small>__CreatedRelative__</small>',
> '<small>__ToldRelative__</small>',
> '<small>__LastUpdatedRelative__</small>',
> '<small>__TimeLeft__</small>',
> '__CustomField.{Rover}__',
_______________________________________________
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