Problem with an 'AdminCC.Name contains foo' Query

Hi,

    I wanted to see tickets for which I was listed as an AdminCC,

so I went into the query builder,
“AdminCC Name” contains “srivasta”; clicked on “add and Search”, and
sure enough, it gave me the list of relevant tickets.

    However, if I try to go to edit the query, or go to the

advanced tab, it says:
EDIT Query:
<* New Search * Edit Search * Advanced * Show Results * Bulk Update>
Results
Unknown field: AdminCc.Name
,----
| AdminCc.Name LIKE ‘srivasta’
`----

    Well, yes, there is no table called AdminCc, so it must have

been a temporary table. But I should be able to build on the query
and save it for the future, no?

    I am using RT 3.6.1 on a Debian testing machine, with

apache2.2 and postresql 8.1 (details below).

    manoj

– System Information:
Debian Release: 4.0
APT prefers testing
APT policy: (500, ‘testing’)
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18.1
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
(ignored: LC_ALL set to en_US.UTF8)

Versions of packages request-tracker3.6 depends on:
ii libapache-session-perl 1.81-1 Perl modules for keeping persisten
ii libcache-cache-perl 1.05-2 Managed caches of persistent infor
ii libcache-simple-timedexpiry- 0.26-1 Perl module to cache and expire ke
ii libcalendar-simple-perl 1.17-2 Perl extension to create simple ca
ii libclass-returnvalue-perl 0.53-1 A return-value object that lets yo
ii libdbd-mysql-perl 3.0008-1 A Perl5 database interface to the
ii libdbd-pg-perl 1.49-2 a PostgreSQL interface for Perl 5
ii libdbd-sqlite3-perl 1.13-1.1 Perl DBI driver with a self-contai
ii libdbi-perl 1.53-1 Perl5 database interface by Tim Bu
ii libdbix-searchbuilder-perl 1.45-1 Encapsulate SQL queries and rows i
ii libexception-class-perl 1.21-1 a module that allows you to declar
ii libfcgi-perl 0.67-2 FastCGI Perl module
ii libfreezethaw-perl 0.43-3 converting Perl structures to stri
ii libgd-graph-perl 1.43.08-2.1 Graph Plotting Module for Perl 5
ii libgd-text-perl 0.86-3 Text utilities for use with GD
ii libhtml-mason-perl 1:1.35-1 HTML::Mason Perl module
ii libhtml-parser-perl 3.55-1 A collection of modules that parse
ii libhtml-scrubber-perl 0.08-3 Perl extension for scrubbing/sanit
ii liblocale-maketext-fuzzy-per 0.02-2 Maketext from already interpolated
ii liblocale-maketext-lexicon-p 0.62-1 Lexicon-handling backends for "Loc
ii liblog-dispatch-perl 2.11-1 Dispatches messages to multiple Lo
ii libmailtools-perl 1.74-0.1 Manipulate email in perl programs
ii libmime-perl 5.420-0.1 Perl5 modules for MIME-compliant m
ii libmldbm-perl 2.01-1 Store multidimensional hash struct
ii libmodule-versions-report-pe 1.02-3 Report versions of all modules in
ii libparams-validate-perl 0.77-1 validate parameters to Perl method
ii libregexp-common-perl 2.120-4 Provide commonly requested regular
ii libterm-readkey-perl 2.30-3 A perl module for simple terminal
ii libtest-inline-perl 2.103-1 Perl extension for embed tests and
ii libtext-autoformat-perl 1.13-1 Perl module for automatic text wra
ii libtext-quoted-perl 1.8-3 Extract the structure of a quoted
ii libtext-template-perl 1.44-1.1 Text::Template perl module
ii libtext-wikiformat-perl 0.78-0.1 translates Wiki formatted text int
ii libtext-wrapper-perl 1.000-2 Simple word wrapping routine
ii libtime-modules-perl 2003.1126-2 Various Perl modules for time/date
ii libtree-simple-perl 1.17-1 A simple tree object
ii libuniversal-require-perl 0.10-1 Load modules from a variable
ii libxml-rss-perl 1.05-1 Perl module for managing RSS (RDF
ii libxml-simple-perl 2.14-5 Perl module for reading and writin
ii perl 5.8.8-6.1 Larry Wall’s Practical Extraction
ii rt3.6-apache2 3.6.1-2 Apache 2 specific files for reques
ii rt3.6-clients 3.6.1-2 Mail gateway and command-line inte
ii sendmail-bin [mail-transport 8.13.8-2 powerful, efficient, and scalable
ii sysklogd [system-log-daemon] 1.4.1-20 System Logging Daemon

Versions of packages request-tracker3.6 recommends:
ii mysql-server 5.0.27-1 mysql database server (meta packag
ii mysql-server-5.0 [mysql-serve 5.0.27-1 mysql database server binaries
ii postgresql 7.5.21 object-relational SQL database man
ii postgresql-8.1 8.1.5-1 object-relational SQL database, ve

Winning isn’t everything, but losing isn’t anything.
Manoj Srivastava srivasta@golden-gryphon.com http://www.golden-gryphon.com/
1024D/BF24424C print 4966 F272 D093 B493 410B 924B 21BA DABB BF24 424C

    I wanted to see tickets for which I was listed as an AdminCC,

so I went into the query builder,
“AdminCC Name” contains “srivasta”; clicked on “add and Search”, and
sure enough, it gave me the list of relevant tickets.

    However, if I try to go to edit the query, or go to the

advanced tab, it says:
EDIT Query:
<* New Search * Edit Search * Advanced * Show Results * Bulk Update>
Results
Unknown field: AdminCc.Name
,----
| AdminCc.Name LIKE ‘srivasta’
`----

   I am using RT 3.6.1 on a Debian testing machine, with

apache2.2 and postresql 8.1 (details below).

Hi,

this is probably Debian bug #400655. Please check if the patch there,
originally from svn.bestpractical.com r5782, helps.

Cheers,
Niko Tyni ntyni@iki.fi

On Mon, 4 Dec 2006 00:00:23 +0200, Niko Tyni
ntyni+rt-users@mappi.helsinki.fi said:> On Sun, Dec 03, 2006 at 01:45:16PM -0600, Manoj Srivastava wrote:

I wanted to see tickets for which I was listed as an AdminCC, so I
went into the query builder, “AdminCC Name” contains “srivasta”;
clicked on “add and Search”, and sure enough, it gave me the list
of relevant tickets.

However, if I try to go to edit the query, or go to the advanced
tab, it says: Results Unknown field: AdminCc.Name

this is probably Debian bug #400655. Please check if the patch
there, originally from svn.bestpractical.com r5782, helps.

    Yes, it did help. The patched Build.html allows the query to

be edited as normal. Thanks for the pointer.

    manoj

Forty two.
Manoj Srivastava srivasta@golden-gryphon.com http://www.golden-gryphon.com/
1024D/BF24424C print 4966 F272 D093 B493 410B 924B 21BA DABB BF24 424C