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

Dale Bewley dlbewley at library.ucdavis.edu
Wed Oct 11 12:36:48 EDT 2006


On Fri, 2006-10-06 at 11:03 -0700, Dale Bewley wrote:
> 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?

Well, apparently there is not yet an ordained method for this. :)
I did find out why the results are blank.

If I modify Elements/ShowSearch to Data::Dumper the $search->Content
hash, I can see that the content from my record does not contain a query
value unlike the content in the default record  #20.

Mine:
$VAR1 = {
          'Order' => 'ASC|ASC|ASC|ASC',
          'OrderBy' => 'id',
          'Format' => '\'<a href="__WebPath__/Ticket/Display.html?id=__id__">__id__</a>/TITLE:#\',
\'<a href="__WebPath__/Ticket/Display.html?id=__id__">__Subject__</a>/TITLE:Subject\',
\'__CustomField.{Department}__/TITLE:Dept\',
\'__CustomField.{SubQueue}__/TITLE:Area\',
\'<Small>__QueueName__</Small>\',
\'<Small>__CreatedRelative__</Small>\',
\'<A HREF="__WebPath__/Ticket/Display.html?Action=Take&id=__id__">__loc(Take)__</a>/TITLE:  \'',
          'RowsPerPage' => '0'
        };

Default:
$VAR1 = {
          'Order' => 'DESC',
          'Query' => ' Owner = \'Nobody\' AND ( Status = \'new\' OR Status = \'open\')',
          'OrderBy' => 'Created',
          'Format' => '\'<a href="__WebPath__/Ticket/Display.html?id=__id__">__id__</a>/TITLE:#\', \'<a href="__WebPath__/Ticket/Display.html?id=__id__">__Subject__</a>/TITLE:Subject\', QueueName, ExtendedStatus, CreatedRelative, \'<A HREF="__WebPath__/Ticket/Display.html?Action=Take&id=__id__">__loc(Take)__</a>/TITLE: \' '
        };

So, I guess if I can hack together some code  to build a suitable hash
then nfreeze and base64 encode it (as seen in Attribute.pm), I'll have a
string that will fit. 

I tried to decode the content field on the cmd line and got a Storable
module error:
Storable binary image v33.81 more recent than I am (v2.7)
at ../../lib/Storable.pm (autosplit
into ../../lib/auto/Storable/thaw.al) line 366

I assume this means there's some difference in Storable.pm as seen by
mod_perl versus perl and that I'll have to do this freezing inside
Mason.

Hints happily accepted.
-- 
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/20061011/028ed16e/attachment.sig>


More information about the rt-users mailing list