[rt-users] Problem with an 'AdminCC.Name contains foo' Query

Manoj Srivastava srivasta at golden-gryphon.com
Sun Dec 3 14:45:16 EST 2006


        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>
 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).


-- 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
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 at golden-gryphon.com> <http://www.golden-gryphon.com/>
1024D/BF24424C print 4966 F272 D093 B493 410B  924B 21BA DABB BF24 424C

More information about the rt-users mailing list