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..<br><br><div><span class="gmail_quote">On 9/21/07, <b class="gmail_sendername">
soma</b> <<a href="mailto:soma@boncle.com">soma@boncle.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">That worked. Thanks Kenn.
<br><br>Soma Manjulavil,<br>Boncle Inc.<br><br>Get a free BoncleExpress from <a href="http://www.boncle.com">http://www.boncle.com</a><br>The assurance of secure messages and transactions<br><br><br>-----Original Message-----
<br>From: Kenneth Crocker [mailto:<a href="mailto:KFCrocker@lbl.gov">KFCrocker@lbl.gov</a>]<br>Sent: Friday, September 21, 2007 11:23 AM<br>To: soma<br>Cc: <a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com
</a><br>Subject: Re: [rt-users] How do I view my custom fields in my ticket query<br>result?<br><br>Soma,<br><br><br> You need to go to the "Advanced" query screen. There, you find where<br><br>the code (bottom box) is displaying the fields and add this
<br><br> '__CustomField.{xxxxxxxxx}__',<br><br>where xxxxxxxxxis the name of the custom field. It is case-sensitive so<br>do not forget the capitols in the name. Put this where you want it to<br>show in your query and that should do it.
<br><br><br>Kenn<br>LBNL<br><br>On 9/21/2007 10:54 AM, soma wrote:<br>> Hi,<br>><br>><br>><br>> We have RT 3.6.4 installed. I was trying to create a query which<br>> shows all the tickets assigned to a specific person. Query is working
<br>> fine. It returns all the rows. My problem is that I am not able to add<br>> the custom fields into my display field list. Custom fields are not<br>> showing-up in the "Display Columns->Add Columns" list box. How can I fix
<br>> this? I need to view the custom fields in my query result. Any help<br>> would be appreciated.<br>><br>><br>><br>> Soma Manjulavil,<br>><br>> Boncle Inc.<br>><br>><br>><br>> Get a free BoncleExpress from
<a href="http://www.boncle.com">http://www.boncle.com</a><br>> <BLOCKED::<a href="http://www.boncle.com">http://www.boncle.com</a>><br>><br>> The assurance of secure messages and transactions<br>><br>>
<br>><br>><br>> ------------------------------------------------------------------------<br>><br>> _______________________________________________<br>> <a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>><br>> Community help: <a href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a><br>> Commercial support: <a href="mailto:sales@bestpractical.com">
sales@bestpractical.com</a><br>><br>><br>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>> Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com
</a><br><br><br>_______________________________________________<br><a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br><br>Community help:
<a href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a><br>Commercial support: <a href="mailto:sales@bestpractical.com">sales@bestpractical.com</a><br><br><br>Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
<br>Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><br></blockquote></div><br>