[rt-users] 3.6.1 change record format on at a glance page

Dale Bewley dlbewley at library.ucdavis.edu
Fri Oct 6 14:03:23 EDT 2006


RT 3.6.1.
I've changed my default search results to include some custom fields by
modifying $DefaultSearchResultFormat in RT_SiteConfig.pm.

Additionally, I want to change the default format on the at a glance
page to include these fields. I found this page
http://wiki.bestpractical.com/index.cgi?ChangeDefaultRTAtAGlance
which is about what is displayed on the page rather than how.

So, I tried to assume and extrapolate like this:

The default search formats are apparently stored in the Attributes table
and created by RT_System i.e. Creator = 1.

mysql> select id, name, description from Attributes where Creator = 1;
+----+--------------------------+-------------------------------------+
| id | name                     | description                         |
+----+--------------------------+-------------------------------------+
| 19 | Search - My Tickets      | [_1] highest priority tickets I own |
| 20 | Search - Unowned Tickets | [_1] newest unowned tickets         |
| 21 | HomepageSettings         | HomepageSettings                    |
+----+--------------------------+-------------------------------------+

As user 104, I customized the search results to my satisfaction.

mysql> select id, name, description from Attributes where Creator = 104;
+----+-----------------------+-------------+
| id | name                  | description |
+----+-----------------------+-------------+
| 22 | Pref-RT::Attribute-19 | NULL        |
| 23 | Pref-SummaryRows      | NULL        |
| 25 | Pref-HomepageSettings | NULL        |
| 26 | Pref-RT::Attribute-20 | NULL        |
+----+-----------------------+-------------+

I then updated the default searches with the content of my customized
search.

mysql> update Attributes set Content = 'BQcDAAAABBc...' where id = 19;
Query OK, 1 row affected (0.04 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> update Attributes set Content = 'BQcDAAAABBcPQ...' where id = 20;
Query OK, 1 row affected (0.04 sec)
Rows matched: 1  Changed: 1  Warnings: 0

But now, the at a glance results are all blank. Is there a better way to
do this, or at least a tweak to this method?
-- 
Dale Bewley - Unix Administrator - Shields Library - UC Davis
GPG: 0xB098A0F3 0D5A 9AEB 43F4 F84C 7EFD  1753 064D 2583 B098 A0F3
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20061006/db3a0922/attachment.sig>


More information about the rt-users mailing list