[rt-users] [PATCH] sorting by custom fields

[Ruslan Zakirov]

Hi, new fixed version of DBIx::SearchBuilder on its way to the CPAN.

Tested with Pg 8.3, mysql 5.0, some SQLite and Oracle 10.

Test on other DBs please.

On Tue, Apr 1, 2008 at 7:51 AM, Ruslan Zakirov <ruz at bestpractical.com> wrote:
> Hi, users,
>
>  Last few days I was hacking on a solution and have something for you to try.
>
>  1) New release of DBIx::SearchBuilder. You can download it from the
>  CPAN near you soon or using
>  http://pause.cpan.org/incoming/DBIx-SearchBuilder-1.52.tar.gz .
>
>  I really recommend you to run make test against your DB server before
>  installing it. Do the following:
>
>  perl Makefile.PL
>  make
>  SB_TEST_MYSQL=db_to_test_in SB_TEST_MYSQL_USER=test_user
>  SB_TEST_MYSQL_PASS=password make test
>
>  Where "db_to_test" is the name of the DB you're going to test against,
>  test files will create temporary tables in that DB. To run it safe use
>  clean DB or DB you use for other experiments, *DON"T RUN TESTS ON
>  ANY DB THAT HAS PRODUCTION DATA*.
>
>  Other valid prefixes for ENV vars are SB_TEST_ORACLE, SB_TEST_PG and
>  SB_TEST_SQLITE.
>
>  Once it succeeded you can run `make install` command.
>  After installing you have to stop and start your web server
>  to apply the changes.
>
>  2) As well I attach patch for RT that should add link to titles of
>  custom field columns in search results. So you can click those to order
>  by a CF and change ordering. To see the change you have to purge mason
>  cache, just drop me a note if you don't know how.
>
>  After installing sorting should be correct in almost all
>  situations, but I know at least one issue when it's not true. The order
>  is wrong when you sort by CF X, limit search by this CF and it can
>  have multiple values. I'm working on a fix for this.
>
>  Waiting for your feedback.
>
>  --
>  Best regards, Ruslan.
>



-- 
Best regards, Ruslan.