[rt-users] custom field display sort & odd workaround

[Kenneth Marshall]

Thank you for the work-around. I am having the same issue.

Ken

On Tue, May 08, 2007 at 11:03:07AM -0400, Jack D. Browning wrote:
> I am new to RT and am very impressed with it.  Thanks Jesse & the community!
> 
> I'm not a programmer, and I'm not sure how useful this post will be.  My apologies if it's inappropriate for some reason.
> 
> I've searched through the mailing list archives & have Googled & can't find a patch or solution for custom fields sorting out of order when displayed in ticket or transaction (comment) pages.  I've seen some posts regarding DBIx::SearchBuilder and possibly Oracle, but can't seem to find anything that applies to PostgreSQL, and am not even sure this is related.
> 
> Problem:
> Custom Fields seemed to display fine when first set up.  Then, after modifying them, they display with a different sort order than originally set up.  The sort fields in the tables did not change.
> 
> Odd Workaround:
> After searching unsuccessfully for a solution, I fiddled around with it some and found that appears to be sorting them based on when the custom fields were last updated.  So, I tried manually editing the lastupdated fields in the tables to get a different sort order, with no effect at all.  However, if I use the web interface to edit each field in the order I want them to appear on the display, it works fine, and appears to work consistently.  So, if I have to change or add a custom field, after I'm done, I just go in and edit each custom field _in the order I want them to display_, by adding or removing a period (.) at the end of each custom field's description field, and it puts them back in the desired order in the display.
> 
> If there is a patch or update I'm missing, or one is coming, I would appreciate a reply post.  Otherwise, I hope this helps isolate this issue for a resolution, or at least helps someone else deal with this for now.
> 
> Running:
> - CentOS 4.4
> - latest RT from head
> - PostgreSQL 8.2
> - Perl 5.8.5
> - DBIx::SearchBuilder 1.48
> 
> 
> Regards,
> 
> Jack D. Browning
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>