[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