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

Kenneth Crocker KFCrocker at lbl.gov
Mon Sep 24 13:27:06 EDT 2007


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}__',



More information about the rt-users mailing list