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 <[EMAIL PROTECTED]> 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. _______________________________________________ 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
