Custom Field as a column in search results?

Hi all!

I have my RT instance set up to have a Change Management queue with the hidden “_Approvals” method (works awesome by the way). Tickets in this queue have a Custom Field set for an “Impact to user” level. I would like to be able to see this CF value as a column in the search results of the “[_1] newest unowned tickets”. Is this possible without major modifications?

Thanks in advance!
Matt Brister, Sr. Desktop Support Analyst (mbrister@talentwise.commailto:mbrister@talentwise.com)
TalentWise

I have my RT instance set up to have a Change Management queue with the hidden “_Approvals"
method (works awesome by the way). Tickets in this queue have a Custom Field set for an
"Impact to user” level. I would like to be able to see this CF value as a column in the search
results of the “[_1] newest unowned tickets”. Is this possible without major modifications?

As a superuser -

Click on Edit, click on Edit this Saved Search, click on Advanced, add
CustomField.{Impact to user} to the search, update the search.

If you were building a Queue specific search, you’d be able to do it
from the normal Format builder at the bottom of the Query builder.

-kevin

Thanks Kevin, Worked like a charm!

-MBFrom: Kevin Falcone <falcone@bestpractical.commailto:Kevin%20Falcone%20<falcone@bestpractical.com>>
Reply-to: rt-users@lists.bestpractical.com
To: rt-users@lists.bestpractical.commailto:rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Custom Field as a column in search results?
Date: Thu, 5 Sep 2013 10:16:06 -0400

I have my RT instance set up to have a Change Management queue with the hidden “_Approvals"
method (works awesome by the way). Tickets in this queue have a Custom Field set for an
"Impact to user” level. I would like to be able to see this CF value as a column in the search
results of the “[_1] newest unowned tickets”. Is this possible without major modifications?

As a superuser -

Click on Edit, click on Edit this Saved Search, click on Advanced, add
CustomField.{Impact to user} to the search, update the search.

If you were building a Queue specific search, you’d be able to do it
from the normal Format builder at the bottom of the Query builder.

-kevin

As a superuser -

Click on Edit, click on Edit this Saved Search, click on Advanced, add
CustomField.{Impact to user} to the search, update the search.

If you were building a Queue specific search, you’d be able to do it
from the normal Format builder at the bottom of the Query builder.

I’m trying to get this working on 4.0.8 (it was working for us on
3.6.7). What I’m seeing is that the search works fine when defined, but
it’s not ‘sticking’ to be the default search as it was before.

Here’s the step-by-step - I’m hoping somebody can point out my error:

  1. log in as root
  2. click the queue in the ‘Quick search’ box
  3. click ‘Edit Search’
  4. in ‘Display Columns’, choose the field, and move it right with the
    arrow button. Adjust position as required.
    4a) tuned it in ‘Advanced’ for layout (definition included below)
  5. click ‘Update Format and Search’ (looks perfect)
  6. verify the custom field is still there by clicking among [Edit,
    Advanced, Show Results] - looks great
  7. return to ‘Home’
  8. click queue again. <<=== Custom Field Gone ===>>

I’m wondering if there is a step 6a)? I’m not seeing any error log
messages about this.

Thanks,
-Bill

id/TITLE:#’,
Subject/TITLE:Subject’,
Status’,
QueueName’,
OwnerName’,
Priority’,
CustomField.{CU Ticket #}’,
NEWLINE’,
’’,
Requestors’,
CreatedRelative’,
ToldRelative’,
LastUpdatedRelative’,
TimeLeft’,
’’

Bill McGonigle, Owner
BFC Computing, LLC
http://bfccomputing.com/
Telephone: +1.855.SW.LIBRE
Email, IM, VOIP: bill@bfccomputing.com
VCard: http://bfccomputing.com/vcard/bill.vcf
Social networks: bill_mcgonigle/bill.mcgonigle

As a superuser -

Click on Edit, click on Edit this Saved Search, click on Advanced, add
CustomField.{Impact to user} to the search, update the search.

If you were building a Queue specific search, you’d be able to do it
from the normal Format builder at the bottom of the Query builder.

I’m trying to get this working on 4.0.8 (it was working for us on
3.6.7). What I’m seeing is that the search works fine when defined, but
it’s not ‘sticking’ to be the default search as it was before.

Here’s the step-by-step - I’m hoping somebody can point out my error:

  1. log in as root
  2. click the queue in the ‘Quick search’ box

I’m not sure why this would have worked on 3.8, because the code is
the same. The Quick Search widget does not have it’s own Format
saved. It uses $DefaultSearchResultFormat set in your
RT_SiteConfig.pm

http://bestpractical.com/docs/rt/latest/RT_Config.html#DefaultSearchResultFormat

The instructions I gave were for editing searches on the home page,
not the quick search.

-kevin