SearchBuilder problems with sorting by Custom Fields

Kenn_Crocker · May 19, 2008, 4:22pm

To all,

I received a complaint from a user that his query wasn't searching by

the custom field he selected, using 3.6.4. I checked it out and sure
enough, it doesn’t work, at all. I read thru almost 100 emails on the RT
subject pertaining to searches that do NOT sort by CF correctly. Joop
said DBx::SearchBuilder needed to be modified, but I never saw anything
that says the problem is fixed. I’m using Oracle. Is there an existing
patch that works for this problem? Is there a new version of
SearchBuilder that handles sorting the results with a CF? It seems this
problem has been around for a long time. Thanks in advance from a
perplexed user.

Kenn
LBNL

Emmanuel_Lacour · May 19, 2008, 8:53pm

To all,

I received a complaint from a user that his query wasn’t searching by
the custom field he selected, using 3.6.4. I checked it out and sure
enough, it doesn’t work, at all. I read thru almost 100 emails on the RT
subject pertaining to searches that do NOT sort by CF correctly. Joop
said DBx::SearchBuilder needed to be modified, but I never saw anything
that says the problem is fixed. I’m using Oracle. Is there an existing
patch that works for this problem? Is there a new version of
SearchBuilder that handles sorting the results with a CF? It seems this
problem has been around for a long time. Thanks in advance from a
perplexed user.

This should be fixed in 3.6.6, can you try it (don’t forget dependencies
via make testdeps)?

Kenn_Crocker · May 19, 2008, 9:32pm

Emmanuel,

I sure try it. I ran the make testdeps for the upgrade to 3.6.4. Were

there some added since then?.

Kenn
LBNLOn 5/19/2008 1:53 PM, Emmanuel Lacour wrote:

On Mon, May 19, 2008 at 09:22:44AM -0700, Kenneth Crocker wrote:

To all,

I received a complaint from a user that his query wasn’t searching by
the custom field he selected, using 3.6.4. I checked it out and sure
enough, it doesn’t work, at all. I read thru almost 100 emails on the RT
subject pertaining to searches that do NOT sort by CF correctly. Joop
said DBx::SearchBuilder needed to be modified, but I never saw anything
that says the problem is fixed. I’m using Oracle. Is there an existing
patch that works for this problem? Is there a new version of
SearchBuilder that handles sorting the results with a CF? It seems this
problem has been around for a long time. Thanks in advance from a
perplexed user.

This should be fixed in 3.6.6, can you try it (don’t forget dependencies
via make testdeps)?

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Kenn_Crocker · May 19, 2008, 9:34pm

Emmanuel,

Also, was the fix to a later version of SearchBuilder? If so, I'd

prefer to just upgrade the SearchBuilder rather than another whole upgrade.

Kenn
LBNLOn 5/19/2008 1:53 PM, Emmanuel Lacour wrote:

On Mon, May 19, 2008 at 09:22:44AM -0700, Kenneth Crocker wrote:

To all,

I received a complaint from a user that his query wasn’t searching by
the custom field he selected, using 3.6.4. I checked it out and sure
enough, it doesn’t work, at all. I read thru almost 100 emails on the RT
subject pertaining to searches that do NOT sort by CF correctly. Joop
said DBx::SearchBuilder needed to be modified, but I never saw anything
that says the problem is fixed. I’m using Oracle. Is there an existing
patch that works for this problem? Is there a new version of
SearchBuilder that handles sorting the results with a CF? It seems this
problem has been around for a long time. Thanks in advance from a
perplexed user.

This should be fixed in 3.6.6, can you try it (don’t forget dependencies
via make testdeps)?

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Emmanuel_Lacour · May 20, 2008, 7:49am

Emmanuel,

Also, was the fix to a later version of SearchBuilder? If so, I’d
prefer to just upgrade the SearchBuilder rather than another whole upgrade.

There is changes in RT and SearchBuilder

You have to install SB 1.53 and to try to applies needed changes from
3.6.6 to 3.6.4 (see svn log).

But I really think that upgrading from 3.6.4 to 3.6.6 is not that
difficult, even with local changes, so I recommends you to take time to
upgrade

Kenn_Crocker · May 20, 2008, 10:11pm

Emmanuel,

I downloaded 3.6.6 and am up to the "make testdeps". This ran fine but

for a couple things missing:

Calendar::Simple…found
DBIx::SearchBuilder 1.50…MISSING
DBIx::SearchBuilder version 1.5 required–this is only
version 1.49 at (eval 27) line 2.
Date::Format…found
CSS::Squish 0.06…MISSING

How do I get the latest SearchBuilder and download it if it wasn't

included in the original download? Why does it state it wants 1.50
instead of 1.53? This is confusing for me.
Thanks for your help.

Kenn
LBNLOn 5/20/2008 12:49 AM, Emmanuel Lacour wrote:

On Mon, May 19, 2008 at 02:34:06PM -0700, Kenneth Crocker wrote:

Emmanuel,

Also, was the fix to a later version of SearchBuilder? If so, I’d
prefer to just upgrade the SearchBuilder rather than another whole upgrade.

There is changes in RT and SearchBuilder

You have to install SB 1.53 and to try to applies needed changes from
3.6.6 to 3.6.4 (see svn log).

But I really think that upgrading from 3.6.4 to 3.6.6 is not that
difficult, even with local changes, so I recommends you to take time to
upgrade

Jesse_Vincent · May 21, 2008, 12:14am

Emmanuel,

I downloaded 3.6.6 and am up to the “make testdeps”. This ran fine
but
for a couple things missing:

Calendar::Simple…found
DBIx::SearchBuilder 1.50…MISSING
DBIx::SearchBuilder version 1.5 required–this is only
version 1.49 at (eval 27) line 2.
Date::Format…found
CSS::Squish 0.06…MISSING

How do I get the latest SearchBuilder and download it if it wasn’t
included in the original download?

‘make fixdeps’ or use ‘cpan’ to manually install it.

Why does it state it wants 1.50 instead of 1.53? This is confusing
for me.

It’s a minimum version requirement. “At least 1.50”

PGP.sig (186 Bytes)

Kenn_Crocker · May 21, 2008, 6:22pm

Jesse, whomever,

I managed to execute the "fixdeps" in my test environment. I wasn't

sure how to answer all the questions on where to put stuff as I know
little or nothing about that stuff, although I AM certainly learning. I
DO have a couple questions about the results. The following is what the
“fixdeps” displayed while doing it’s thing:

CPAN.pm: Going to build R/RU/RUZ/DBIx-SearchBuilder-1.53.tar.gz

Cannot determine perl version info from SearchBuilder.pm
*** Module::AutoInstall version 1.03
*** Checking for Perl dependencies…
[Core Features]

Test::More …loaded. (0.62 >= 0.52)
DBD::SQLite …loaded. (1.11)
File::Temp …loaded. (0.16)
DBI …loaded. (1.47)
Want …loaded. (0.10)
Encode …loaded. (2.01)
Class::ReturnValue …loaded. (0.53 >= 0.4)
Cache::Simple::TimedExpiry …loaded. (0.23 >= 0.21)
Clone …loaded. (0.20)
[Lower case API]
capitalization …loaded. (0.03 >= 0.03)
[Schema generation]
DBIx::DBSchema …loaded. (0.33)
Class::Accessor …loaded. (0.22)
*** Module::AutoInstall configuration finished.
Checking if your kit is complete…
Looks good
Writing Makefile for DBIx::SearchBuilder
make[1]: Entering directory
/home/rt/.cpan/build/DBIx-SearchBuilder-1.53-x0hO2K' cp SearchBuilder.pm blib/lib/DBIx/SearchBuilder.pm cp SearchBuilder/Handle.pm blib/lib/DBIx/SearchBuilder/Handle.pm cp SearchBuilder/Handle/mysqlPP.pm blib/lib/DBIx/SearchBuilder/Handle/mysqlPP.pm cp SearchBuilder/Handle/mysql.pm blib/lib/DBIx/SearchBuilder/Handle/mysql.pm cp SearchBuilder/Handle/Sybase.pm blib/lib/DBIx/SearchBuilder/Handle/Sybase.pm cp SearchBuilder/Unique.pm blib/lib/DBIx/SearchBuilder/Unique.pm cp SearchBuilder/Union.pm blib/lib/DBIx/SearchBuilder/Union.pm cp SearchBuilder/Handle/Oracle.pm blib/lib/DBIx/SearchBuilder/Handle/Oracle.pm cp SearchBuilder/Record/Cachable.pm blib/lib/DBIx/SearchBuilder/Record/Cachable.pm cp SearchBuilder/Handle/Informix.pm blib/lib/DBIx/SearchBuilder/Handle/Informix.pm cp SearchBuilder/Handle/SQLite.pm blib/lib/DBIx/SearchBuilder/Handle/SQLite.pm cp SearchBuilder/Handle/ODBC.pm blib/lib/DBIx/SearchBuilder/Handle/ODBC.pm cp SearchBuilder/Handle/Pg.pm blib/lib/DBIx/SearchBuilder/Handle/Pg.pm cp SearchBuilder/SchemaGenerator.pm blib/lib/DBIx/SearchBuilder/SchemaGenerator.pm cp SearchBuilder/Record.pm blib/lib/DBIx/SearchBuilder/Record.pm Manifying blib/man3/DBIx::SearchBuilder::Handle::mysql.3 Manifying blib/man3/DBIx::SearchBuilder::Handle::mysqlPP.3 Manifying blib/man3/DBIx::SearchBuilder::Handle.3 Manifying blib/man3/DBIx::SearchBuilder.3 Manifying blib/man3/DBIx::SearchBuilder::Handle::Sybase.3 Manifying blib/man3/DBIx::SearchBuilder::Union.3 Manifying blib/man3/DBIx::SearchBuilder::Unique.3 Manifying blib/man3/DBIx::SearchBuilder::Record::Cachable.3 Manifying blib/man3/DBIx::SearchBuilder::Handle::Oracle.3 Manifying blib/man3/DBIx::SearchBuilder::Handle::SQLite.3 Manifying blib/man3/DBIx::SearchBuilder::Handle::Informix.3 Manifying blib/man3/DBIx::SearchBuilder::Handle::Pg.3 Manifying blib/man3/DBIx::SearchBuilder::Handle::ODBC.3 Manifying blib/man3/DBIx::SearchBuilder::Record.3 Manifying blib/man3/DBIx::SearchBuilder::SchemaGenerator.3 make[1]: Leaving directory /home/rt/.cpan/build/DBIx-SearchBuilder-1.53-x0hO2K’
RUZ/DBIx-SearchBuilder-1.53.tar.gz
/tools/bin/make – OK
Running make test
make[1]: Entering directory
`/home/rt/.cpan/build/DBIx-SearchBuilder-1.53-x0hO2K’
PERL_DL_NONLAZY=1 /tools/bin/perl “-MExtUtils::Command::MM” “-e”
“test_harness(0, ‘inc’, ‘blib/lib’, ‘blib/arch’)” t/00.load.t
t/01basics.t t/01nocap_api.t t/01records.t t/01searches.t
t/02order_outer.t t/02records_cachable.t t/02records_integers.t
t/02records_object.t t/02searches_joins.t t/03rebless.t
t/03transactions.t t/03versions.t t/10schema.t t/11schema_records.t t/pod.t
t/00.load…ok

t/01basics…ok

t/01nocap_api…ok

t/01records…ok

     65/65 skipped: various reasons

t/01searches…ok

     76/76 skipped: various reasons

t/02order_outer…ok

     98/98 skipped: various reasons

t/02records_cachable…ok

     16/16 skipped: various reasons

t/02records_integers…ok

     33/33 skipped: various reasons

t/02records_object…ok

     11/11 skipped: various reasons

t/02searches_joins…ok

     47/47 skipped: various reasons

t/03rebless…ok

     4/4 skipped: various reasons

t/03transactions…ok

     42/42 skipped: various reasons

t/03versions…ok

     6/6 skipped: various reasons

t/10schema…ok

     14/17 skipped: various reasons

t/11schema_records…ok

     63/63 skipped: various reasons

t/pod…skipped
all skipped: Test::Pod 1.00 required for testing POD
All tests successful, 1 test and 475 subtests skipped.
Files=16, Tests=496, 13 wallclock secs ( 6.87 cusr + 2.22 csys = 9.09 CPU)
make[1]: Leaving directory
/home/rt/.cpan/build/DBIx-SearchBuilder-1.53-x0hO2K' RUZ/DBIx-SearchBuilder-1.53.tar.gz /tools/bin/make test -- OK Running make install make[1]: Entering directory /home/rt/.cpan/build/DBIx-SearchBuilder-1.53-x0hO2K’
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder.pm
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Handle.pm
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Unique.pm
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Union.pm
Installing
/opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/SchemaGenerator.pm
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Record.pm
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Handle/mysqlPP.pm
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Handle/mysql.pm
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Handle/Sybase.pm
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm
Installing
/opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Handle/Informix.pm
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Handle/SQLite.pm
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Handle/ODBC.pm
Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Handle/Pg.pm
Installing
/opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder/Record/Cachable.pm
Installing /opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Handle::mysql.3
Installing
/opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Handle::mysqlPP.3
Installing /opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Handle.3
Installing /opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder.3
Installing /opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Handle::Sybase.3
Installing /opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Union.3
Installing /opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Unique.3
Installing
/opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Record::Cachable.3
Installing /opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Handle::Oracle.3
Installing /opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Handle::SQLite.3
Installing
/opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Handle::Informix.3
Installing /opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Handle::Pg.3
Installing /opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Handle::ODBC.3
Installing /opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::Record.3
Installing
/opt/rt-3.4.4/perl/man/man3/DBIx::SearchBuilder::SchemaGenerator.3
Writing
/opt/rt-3.4.4/perl/lib/5.8.5/sun4-solaris/auto/DBIx/SearchBuilder/.packlist
Appending installation info to
/opt/rt-3.4.4/perl/lib/5.8.5/sun4-solaris/perllocal.pod
make[1]: Leaving directory
`/home/rt/.cpan/build/DBIx-SearchBuilder-1.53-x0hO2K’
RUZ/DBIx-SearchBuilder-1.53.tar.gz
/tools/bin/make install – OK

Install module CSS::Squish
Running install for module ‘CSS::Squish’
Running make for R/RU/RUZ/CSS-Squish-0.07.tar.gz
Fetching with LWP:

ftp://cpan.cs.utah.edu/pub/CPAN/authors/id/R/RU/RUZ/CSS-Squish-0.07.tar.gz
Checksum for
/home/rt/.cpan/sources/authors/id/R/RU/RUZ/CSS-Squish-0.07.tar.gz ok
CSS-Squish-0.07/
CSS-Squish-0.07/t/
CSS-Squish-0.07/t/05-basic-loop-prevention.t
CSS-Squish-0.07/t/css/
CSS-Squish-0.07/t/css/01-basic-import.css
CSS-Squish-0.07/t/css/05-loop-prevention-2.css
CSS-Squish-0.07/t/css/05-loop-prevention.css
CSS-Squish-0.07/t/css/04-recursion.css
CSS-Squish-0.07/t/css/blam.css
CSS-Squish-0.07/t/css/foo/
CSS-Squish-0.07/t/css/foo/04-recursion-2.css
CSS-Squish-0.07/t/css/foo/04-recursion-3.css
CSS-Squish-0.07/t/css/01-basic.css
CSS-Squish-0.07/t/css/03-skip-http.css
CSS-Squish-0.07/t/css/foo.css
CSS-Squish-0.07/t/css/02-edge-cases.css
CSS-Squish-0.07/t/css/07-basic-extra-roots4.css
CSS-Squish-0.07/t/css/05-loop-prevention-3.css
CSS-Squish-0.07/t/css/foo2.css
CSS-Squish-0.07/t/css/07-basic-extra-roots.css
CSS-Squish-0.07/t/css/07-basic-extra-roots3.css
CSS-Squish-0.07/t/99-pod-coverage.t
CSS-Squish-0.07/t/css3/
CSS-Squish-0.07/t/css3/07-basic-extra-roots2.css
CSS-Squish-0.07/t/css3/07-basic-extra-roots3.css
CSS-Squish-0.07/t/03-skip-http.t
CSS-Squish-0.07/t/07-basic-extra-roots.t
CSS-Squish-0.07/t/css2/
CSS-Squish-0.07/t/css2/07-basic-extra-roots2.css
CSS-Squish-0.07/t/02-edge-cases.t
CSS-Squish-0.07/t/00-use.t
CSS-Squish-0.07/t/01-basic.t
CSS-Squish-0.07/t/04-recursion.t
CSS-Squish-0.07/t/06-server-relative-urls.t
CSS-Squish-0.07/t/99-pod.t
CSS-Squish-0.07/MANIFEST
CSS-Squish-0.07/CHANGES
CSS-Squish-0.07/lib/
CSS-Squish-0.07/lib/CSS/
CSS-Squish-0.07/lib/CSS/Squish.pm
CSS-Squish-0.07/Makefile.PL
CSS-Squish-0.07/README
CSS-Squish-0.07/META.yml

CPAN.pm: Going to build R/RU/RUZ/CSS-Squish-0.07.tar.gz

Checking if your kit is complete…
Looks good
Writing Makefile for CSS::Squish
make[1]: Entering directory /home/rt/.cpan/build/CSS-Squish-0.07-0j3Lwu' cp lib/CSS/Squish.pm blib/lib/CSS/Squish.pm Manifying blib/man3/CSS::Squish.3 make[1]: Leaving directory /home/rt/.cpan/build/CSS-Squish-0.07-0j3Lwu’
RUZ/CSS-Squish-0.07.tar.gz
/tools/bin/make – OK
Running make test
make[1]: Entering directory `/home/rt/.cpan/build/CSS-Squish-0.07-0j3Lwu’
PERL_DL_NONLAZY=1 /tools/bin/perl “-MExtUtils::Command::MM” “-e”
“test_harness(0, ‘blib/lib’, ‘blib/arch’)” t/*.t
t/00-use…ok

t/01-basic…ok

t/02-edge-cases…ok

t/03-skip-http…ok

t/04-recursion…ok

t/05-basic-loop-prevention…ok

t/06-server-relative-urls…skipped
all skipped: Functionality non-existant. (and tests incomplete.)
t/07-basic-extra-roots…ok

t/99-pod-coverage…skipped
all skipped: Test::Pod::Coverage 1.00 required for testing POD
coverage
t/99-pod…skipped
all skipped: Test::Pod 1.00 required for testing POD
All tests successful, 3 tests skipped.
Files=10, Tests=13, 3 wallclock secs ( 1.34 cusr + 0.59 csys = 1.93 CPU)
make[1]: Leaving directory /home/rt/.cpan/build/CSS-Squish-0.07-0j3Lwu' RUZ/CSS-Squish-0.07.tar.gz /tools/bin/make test -- OK Running make install make[1]: Entering directory /home/rt/.cpan/build/CSS-Squish-0.07-0j3Lwu’
Installing /opt/rt-3.4.4/perl/lib/5.8.5/CSS/Squish.pm
Installing /opt/rt-3.4.4/perl/man/man3/CSS::Squish.3
Writing /opt/rt-3.4.4/perl/lib/5.8.5/sun4-solaris/auto/CSS/Squish/.packlist
Appending installation info to
/opt/rt-3.4.4/perl/lib/5.8.5/sun4-solaris/perllocal.pod
make[1]: Leaving directory `/home/rt/.cpan/build/CSS-Squish-0.07-0j3Lwu’
RUZ/CSS-Squish-0.07.tar.gz
/tools/bin/make install – OK
MAILGATE dependencies:
Pod::Usage…found
HTML::TreeBuilder…found
Getopt::Long…found
HTML::FormatText…found
LWP::UserAgent…found
MASON dependencies:
CGI::Cookie >=1.20…found
Text::WikiFormat >=0.76…found
XML::RSS >=1.05…found
Storable >=2.08…found
CSS::Squish 0.06…MISSING
HTML::Mason >=1.23…found
Apache::Session >=1.53…found
Digest::MD5 >=2.27…found
GD::Text…found
GD…found
Errno…found
GD::Graph…found

Install module CSS::Squish
Running install for module ‘CSS::Squish’
Running make for R/RU/RUZ/CSS-Squish-0.07.tar.gz
Has already been unwrapped into directory
/home/rt/.cpan/build/CSS-Squish-0.07-0j3Lwu
Has already been made
Running make test
Has already been tested successfully
Running make install
Already done
ORACLE dependencies:
DBD::Oracle…found

SOMETHING WAS MISSING!
bash-2.03$

My questions are:

1) When it states "1 test and 475 skipped" is that bad?
2) When is showed where it was installing everything, it displayed

“Installing /opt/rt-3.4.4/perl/lib/5.8.5/DBIx/SearchBuilder”

So ..... why didn't it install to rt-3.6.6   AND
3) We are using perl 5.8.8, so I am concerned about those results or

directory or whatever as well.
4) What is “Squish” and did that install OK?

I just can't tell on some of this stuff. When it asks questions like

“Always commit changes to config variables to disk? [no]” do I enter
“y”, “yes”, “no” or just hit enter?

When it asked about building perl, I thought I should enter where we

keep our perL. Correct??

Parameters for the ‘perl Build.PL’ command?
Typical frequently used settings:

 --install_base /home/xxx             # different installation directory

Your choice: /apps/rt/rt-3.6.6/perl
Parameters for the ‘./Build’ command?

So .... can anyone tell me what I did? did it work? did it go where I

thought it should go? Did I enter the right answers to it’s questions?
Have I successfully installed SearchBuilder 1.5.3 or is everything back
to 3.4.4?

I VERY confused by these questions AND results. Please help and Thanks

ahead of time.

Kenn
LBNLOn 5/20/2008 5:14 PM, Jesse Vincent wrote:

On May 21, 2008, at 6:11 AM, Kenneth Crocker wrote:
Emmanuel,
I downloaded 3.6.6 and am up to the "make testdeps". This ran fine 
but
for a couple things missing:

Calendar::Simple…found
DBIx::SearchBuilder 1.50…MISSING
DBIx::SearchBuilder version 1.5 required–this is only
version 1.49 at (eval 27) line 2.
Date::Format…found
CSS::Squish 0.06…MISSING
How do I get the latest SearchBuilder and download it if it wasn't
included in the original download?
‘make fixdeps’ or use ‘cpan’ to manually install it.

Why does it state it wants 1.50 instead of 1.53? This is confusing for
me.

It’s a minimum version requirement. “At least 1.50”

Kenn_Crocker · May 27, 2008, 7:40pm

Jesse, Emmanuel,

Thanks! I finally got it. Boy, do I need to learn some on this install

stuff. I now have 3.6.6 up and running. Looks great!
I am STILL having trouble getting a search to sort results by a Custom
Field. Is there some limitation that only allows this to work if the CF
is defined as numeric? Or something like that? Thanks for your help.

Kenn
LBNLOn 5/20/2008 5:14 PM, Jesse Vincent wrote:

On May 21, 2008, at 6:11 AM, Kenneth Crocker wrote:
Emmanuel,
I downloaded 3.6.6 and am up to the "make testdeps". This ran fine 
but
for a couple things missing:

Calendar::Simple…found
DBIx::SearchBuilder 1.50…MISSING
DBIx::SearchBuilder version 1.5 required–this is only
version 1.49 at (eval 27) line 2.
Date::Format…found
CSS::Squish 0.06…MISSING
How do I get the latest SearchBuilder and download it if it wasn't
included in the original download?
‘make fixdeps’ or use ‘cpan’ to manually install it.

Why does it state it wants 1.50 instead of 1.53? This is confusing for
me.

It’s a minimum version requirement. “At least 1.50”

Emmanuel_Lacour · May 28, 2008, 3:54pm

Jesse, Emmanuel,

Thanks! I finally got it. Boy, do I need to learn some on this install
stuff. I now have 3.6.6 up and running. Looks great!
I am STILL having trouble getting a search to sort results by a Custom
Field. Is there some limitation that only allows this to work if the CF
is defined as numeric? Or something like that? Thanks for your help.

It works here for CFs of type “select one value” and “Select multiple
values” with text contents.

Jesse_Vincent · May 28, 2008, 3:56pm

Jesse, Emmanuel,
Thanks! I finally got it. Boy, do I need to learn some on this install  
stuff. I now have 3.6.6 up and running. Looks great!
I am STILL having trouble getting a search to sort results by a Custom
Field. Is there some limitation that only allows this to work if the CF
is defined as numeric? Or something like that? Thanks for your help.
It works here for CFs of type “select one value” and “Select multiple
values” with text contents.

We’ve done an awful lot of work on this for what will become RT 3.6.7
when we get a free moment.

Kenn_Crocker · May 28, 2008, 4:12pm

Jesse, Emmanuel,

Thanks. Good to hear about 3.6.7. Emmanuel, if yours is working, then

maybe my install of 3.6.6 didn’t get the latest SearchBuilder. To be
honest, the fact that it doesn’t work for CF’s is NOT a show-stopper. It
will be a GREAT asset for administrative reporting when it does, but in
the meantime, I’m now up to 3.6.6 and everything else works incredibly
well. In fact, I have a new technical support group that will need to
add about 85 new application support queues. It just keeps getting
bigger and better, really. Now that our approval/priority & QA workflow
processes (scrips) are up and running, we have the infrastructure to
handle that many queues easily.

Kenn
LBNLOn 5/28/2008 8:56 AM, Jesse Vincent wrote:

On Wed, May 28, 2008 at 05:54:09PM +0200, Emmanuel Lacour wrote:

On Tue, May 27, 2008 at 12:40:53PM -0700, Kenneth Crocker wrote:

Jesse, Emmanuel,

Thanks! I finally got it. Boy, do I need to learn some on this install
stuff. I now have 3.6.6 up and running. Looks great!
I am STILL having trouble getting a search to sort results by a Custom
Field. Is there some limitation that only allows this to work if the CF
is defined as numeric? Or something like that? Thanks for your help.

It works here for CFs of type “select one value” and “Select multiple
values” with text contents.

We’ve done an awful lot of work on this for what will become RT 3.6.7
when we get a free moment.

Kenn_Crocker · May 29, 2008, 3:49pm

Jesse,

Any idea when you think 3.6.7 will be consumer-ready?

Kenn
LBNLOn 5/28/2008 8:56 AM, Jesse Vincent wrote:

On Wed, May 28, 2008 at 05:54:09PM +0200, Emmanuel Lacour wrote:

On Tue, May 27, 2008 at 12:40:53PM -0700, Kenneth Crocker wrote:

Jesse, Emmanuel,

Thanks! I finally got it. Boy, do I need to learn some on this install
stuff. I now have 3.6.6 up and running. Looks great!
I am STILL having trouble getting a search to sort results by a Custom
Field. Is there some limitation that only allows this to work if the CF
is defined as numeric? Or something like that? Thanks for your help.

It works here for CFs of type “select one value” and “Select multiple
values” with text contents.

We’ve done an awful lot of work on this for what will become RT 3.6.7
when we get a free moment.

Jesse_Vincent · May 29, 2008, 4:04pm

Jesse,

Any idea when you think 3.6.7 will be consumer-ready?

We’re somewhat more focused on 3.8rc1 at the moment. I don’t have a
firm date.

PGP.sig (186 Bytes)

Kenn_Crocker · May 29, 2008, 4:27pm

Jesse,

That's kool. I was just curious.

Kenn
LBNLOn 5/29/2008 9:04 AM, Jesse Vincent wrote:

On May 29, 2008, at 11:49 AM, Kenneth Crocker wrote:
Jesse,
Any idea when you think 3.6.7 will be consumer-ready?
We’re somewhat more focused on 3.8rc1 at the moment. I don’t have a firm
date.