Jeff & Justin, Thanks for the input.
As far as I can tell at this point, there is no more information I can provide to help resolve this, and it's a matter of a possible patch being further tested and rolled into the codebase. If I am incorrect on this point, and/or if there is something else I can do to further a solution, please do let me know. Thanks, Jack B. >> Joop provided the patch. >> The issue that we saw regarding not returning all the records was cured by >> determining if the value entered was numerical and searching different >> fields for the value as opposed to when a String value was entered. >> - Stark >> >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of Justin >> Brodley >> Sent: Tuesday, May 08, 2007 12:58 PM >> To: Jack D. Browning; rt-users >> Subject: RE: [rt-users] custom field display sort & odd workaround >> I know that we got a patch from someone on this mailing list. The patch >> wasn't rolled into the code tree as there was some concern that certain >> results were hidden from the searches. We haven't seen this issue on our >> Oracle implementation, and someone who is more familiar with the code >> should probably re-review and determine if it should be checked into the >> code tree as it does resolves this issue. >> Justin Brodley >> >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of Jack D. >> Browning >> Sent: Tuesday, May 08, 2007 8:03 AM >> To: rt-users >> Subject: [rt-users] custom field display sort & odd workaround >> 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: >> [EMAIL PROTECTED] >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >> Buy a copy at http://rtbook.bestpractical.com >> _______________________________________________ >> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >> Community help: http://wiki.bestpractical.com Commercial support: >> [EMAIL PROTECTED] >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >> Buy a copy at http://rtbook.bestpractical.com _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
