Re: [rt-users] custom field display sort odd workaround
Jack D. Browning wrote: Also, as noted by Justin Brodley and Jeff Stark in this thread, there may be a patch available that resolves this, but apparently it's not been rolled up into the main codebase. The only patch that I was aware of from the archives was in fact submitted by Joop, but it appears to affect the Oracle.pm file as far as I can tell. I fixed this for Oracle since we're using that. It has todo with a change introduced for Pg but it was also applied to Oracle and maybe also to MySQL, I didn't check that. Have a look at it and see if the outlined method also works on Pg. My patch should be in the archives, probably the devellist. Joop ___ 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
RE: [rt-users] DB Query
Hi,
In our RT we have a ticket-custom field holding the Customer Id. The
following SQL shows the number of tickets per customer id:
select
objcf1.content CustomerId, count(*) TicketCount
from
tickets, customfields cf1, objectcustomfieldvalues objcf1
where
objcf1.objectid=tickets.id
and objcf1.objecttype='RT::Ticket'
and objcf1.customfield=cf1.id
and cf1.name='Customer ID'
and tickets.status in ('new','open','stalled','offer')
group by
objcf1.content
The syntax for the SQL may vary depending on the database (we're running
Oracle).
/Steen
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of John Paul
Hayes
Sent: Tuesday, May 08, 2007 6:25 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] DB Query
Hi All,
I am running a script with accesses the rtdb directly (for speed
purposes). One of the requirements is that I have to
find any ticket what was resolved with a custom field entry
selected.
Does anybody know off hand how to link a ticket id to the custom
field entry id in the db?
Thanks in advance,
JP
--
If you make people think they're thinking, they'll love you;
but if you really make them think they'll hate you.
- Don Marquis
___
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
Re: [rt-users] RT 4
Alle 19:31, martedì 8 maggio 2007, [EMAIL PROTECTED] ha scritto: I also want to be able to setup the MTA configuration from within the GUI. I think this is not a good idea: in an heavy duty environment, MTAs simply are on different servers then webinterface. Also MTAs configuration is a totally separated job, MTAs can get information from a big plethora of sources: AD/LDAP, SASL, DB, local files... In a small environment with low traffic and only one poor lerned sysadm, MTA configuration from webinterface should be a good start point, but it can be optional and not mandatory, otherwise RT will not be a good choice for large installation. -- Luca VillaniMobile Team, Dada S.p.A. Tel: +39 055 2267220Mob: +39 335 8753086 ICQ: 76272621 Skype: luca.villani GPG key fingerprint: 7FC9 E2FE 0BEE 9DF8 1719 8761 1B79 82CC F0B5 B7CF ___ 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
Re: [rt-users] DB Query
Hi All,
Thank you for the help, very much appreciated.
On 5/9/07, Steen Olesen [EMAIL PROTECTED] wrote:
Hi,
In our RT we have a ticket-custom field holding the Customer Id. The
following SQL shows the number of tickets per customer id:
select
objcf1.content CustomerId, count(*) TicketCount
from
tickets, customfields cf1, objectcustomfieldvalues objcf1
where
objcf1.objectid=tickets.id
and objcf1.objecttype='RT::Ticket'
and objcf1.customfield=cf1.id
and cf1.name='Customer ID'
and tickets.status in ('new','open','stalled','offer')
group by
objcf1.content
The syntax for the SQL may vary depending on the database (we're running
Oracle).
/Steen
--
*From:* [EMAIL PROTECTED] [mailto:
[EMAIL PROTECTED] *On Behalf Of *John Paul Hayes
*Sent:* Tuesday, May 08, 2007 6:25 PM
*To:* rt-users@lists.bestpractical.com
*Subject:* [rt-users] DB Query
Hi All,
I am running a script with accesses the rtdb directly (for speed
purposes). One of the requirements is that I have to
find any ticket what was resolved with a custom field entry selected.
Does anybody know off hand how to link a ticket id to the custom field
entry id in the db?
Thanks in advance,
JP
--
If you make people think they're thinking, they'll love you; but if you
really make them think they'll hate you.
— Don Marquis
--
If you make people think they're thinking, they'll love you; but if you
really make them think they'll hate you.
— Don Marquis
___
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
[rt-users] RT 3.6.3 error
Hi Guys,
I'm hoping somebody can point me to a solution to this error. Trying to
upgrade our test instance from 3.4.6 to 3.6.3.
Ran the upgrade for etc/upgrade/3.5.1/content, restarted, flushed caches
etc and when logging in see this error:
*error:* Can't use string () as a HASH ref while strict refs in
use at /opt/rt3/share/html/Elements/MyRT line 50.
*context:*
*...*
*46:* table border=0 width=100%
*47:* tr valign=top
*48:* td width=70% class=boxcontainer
*49:*
*50:* % for my $portlet (@{$portlets-{body}}) {
*51:* % $show_cb-( $portlet ) %
*52:* br /
*53:* % }
*54:*
*...*
*code stack:* /opt/rt3/share/html/Elements/MyRT:50
/opt/rt3/share/html/index.html:79
/opt/rt3/share/html/autohandler:292
Removed our complete rt3 instance and ran make install, only copying the
RT_SiteConfig.pm file across to the new directory and see the same error
Raw error is:
Can't use string () as a HASH ref while strict refs in use at
/opt/rt3/share/html/Elements/MyRT line 50.
Trace begun at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Exceptions.pm
line 131
HTML::Mason::Exceptions::rethrow_exception('Can\'t use string () as a HASH ref while
strict refs in use at /opt/rt3/share/html/Elements/MyRT line 50.^J') called at
/opt/rt3/share/html/Elements/MyRT line 50
HTML::Mason::Commands::__ANON__ at
/usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Component.pm line 134
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x1857168)')
called at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Request.pm line 1074
eval {...} at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Request.pm line
1068
HTML::Mason::Request::comp(undef, undef) called at
/opt/rt3/share/html/index.html line 79
HTML::Mason::Commands::__ANON__ at
/usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Component.pm line 134
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x17679ac)')
called at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Request.pm line 1074
eval {...} at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Request.pm line
1068
HTML::Mason::Request::comp(undef, undef, undef) called at
/opt/rt3/share/html/autohandler line 292
HTML::Mason::Commands::__ANON__ at
/usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Component.pm line 134
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x1794ce8)')
called at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Request.pm line 1069
eval {...} at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Request.pm line
1068
HTML::Mason::Request::comp(undef, undef, undef) called at
/usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Request.pm line 338
eval {...} at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Request.pm line
338
eval {...} at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Request.pm line
297
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x112b300)')
called at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/ApacheHandler.pm
line 134
eval {...} at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/ApacheHandler.pm
line 134
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x112b300)')
called at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/ApacheHandler.pm
line 792
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x128c928)',
'Apache=SCALAR(0x106490)') called at /opt/rt3/bin/webmux.pl line 123
eval {...} at /opt/rt3/bin/webmux.pl line 123
RT::Mason::handler('Apache=SCALAR(0x106490)') called at /dev/null line 0
eval {...} at /dev/null line 0
make testdeps output is:
/usr/local/bin/perl ./sbin/rt-test-dependencies --verbose --with-mysql
perl:
=5.8.3(5.008004)...found
users:
rt group (rt)...found
bin owner (root)...found
libs owner (root)...found
libs group (bin)...found
web owner (rtuser)...found
web group (rtusers)...found
CLI dependencies:
Getopt::Long =2.24...found
CORE dependencies:
Digest::base...found
Digest::MD5 =2.27...found
DBI =1.37...found
Test::Inline...found
Class::ReturnValue =0.40...found
Date::Format...found
DBIx::SearchBuilder =1.40...found
Text::Template...found
File::Spec =0.8...found
HTML::Entities...found
HTML::Scrubber =0.08...found
Net::Domain...found
Log::Dispatch =2.0...found
Locale::Maketext =1.06...found
Locale::Maketext::Lexicon =0.32...found
Locale::Maketext::Fuzzy...found
MIME::Entity =5.108...found
Mail::Mailer =1.57...found
Net::SMTP...found
Text::Wrapper...found
Time::ParseDate...found
Time::HiRes...found
File::Temp...found
Term::ReadKey...found
Text::Autoformat...found
Text::Quoted =1.3...found
Tree::Simple =1.04...found
Scalar::Util...found
Module::Versions::Report...found
Cache::Simple::TimedExpiry...found
[rt-users] Custom Fields for Users
Hi All, I noticed that you can create a Custom Field for Users and tried it out, but how do you get it to show up? I created the Custom Field, gave full access to Everyone to it, then went and looked at a user record. The Custom Field area showed up on the user page, but there weren't any fields in area.. What am I missing? -- Kelly F. Hickel Senior Software Architect MQSoftware, Inc 952.345.8677 [EMAIL PROTECTED] ___ 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
RE: [rt-users] Custom Fields for Users
Found the answer. To assign custom fields to users, logged in as root, do the following: 1) Click Configuration in the top menu bar 2) Click Global from the list of items 3) Click on Custom Fields from the list of items 4) Click on Users from the list of items Now you can select which Custom Fields apply to all users. -- Kelly F. Hickel Senior Software Architect MQSoftware, Inc 952.345.8677 [EMAIL PROTECTED] From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kelly F. Hickel Sent: Wednesday, May 09, 2007 6:34 AM To: RT Users Subject: [rt-users] Custom Fields for Users Hi All, I noticed that you can create a Custom Field for Users and tried it out, but how do you get it to show up? I created the Custom Field, gave full access to Everyone to it, then went and looked at a user record. The Custom Field area showed up on the user page, but there weren't any fields in area.. What am I missing? -- Kelly F. Hickel Senior Software Architect MQSoftware, Inc 952.345.8677 [EMAIL PROTECTED] ___ 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
Re: [rt-users] Custom Status/Ticket disappears: Take 3
I've looked through various files again. Some new ones like Queue_Overlay.pm
adding my custom status to @DEFAULT_ACTIVE_STATUS. However, since it appears to
be able to get the information somewhere else, the ActiveStatusArray method
never gets to the point where it has to use the default.
I can't find where it is getting its information from so it will show up in 10
Tickets I Own. Any help will be appreciated.
Mathew
Keep up with me and what I'm up to: http://theillien.blogspot.com
Mathew Snyder wrote:
I've got the status showing up in QuickSearch and it displays the tickets
therein. However, I can't seem to figure out how to adjust 10 Tickets I Own
section. The search for that only lists new, open or stalled tickets. Where
do
I adjust this query. I've looked in several files under Elements/ but can't
find the file containing this query.
Mathew
Torsten Brumm wrote:
Here is a simple example for quicksearch:
div class=ticket-overview
|/Widgets/TitleBox, title = loc(Quick search), bodyclass = ,
titleright = loc(Edit), titleright_href =
$RT::WebPath.'/Prefs/Quicksearch.html'
/Elements/QueueSummary,
cache = 'quick_search_queues',
queue_filter = sub { $_-CurrentUserHasRight('ShowTicket')
!exists $unwanted-{$_-Name} },
conditions = [ {cond = Status = 'new', name = loc ('new') },
{cond = Status = 'open', name = loc ('open') },
{cond = Status = 'accepted', name = loc
('accepted') },
{cond = Status = 'implement', name = loc
('implemented') },
{cond = Status = 'approved', name = loc
('approved') },
{cond = Status = 'stalled', name = loc ('stalled') },
{cond = Status = 'pending', name = loc
('pending') },
{cond = Status = 'authorized', name = loc
('authorized') },
{cond = Status = 'resolved', name = loc
('resolved') }]
/
/div
%INIT
my $unwanted =
$session{'CurrentUser'}-UserObj-Preferences('QuickSearch', {});
/%INIT
i had to add my custom status to this file.
For the rest like tickets i own and so on, its enough if you go to edit
in this module and edit the search string.
Torsten
2007/4/18, Mathew Snyder [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]:
I used the method in the wiki for adding a custom active status to my
configuration (development box). It shows up fine. However, when I
select it,
ticket I've applied it to disappears from my list of owned
tickets. How can I
adjust this to force the ticket to stay available the way stalled does?
Thanks
Mathew
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
--
MFG
Torsten Brumm
http://www.torsten-brumm.de http://www.torsten-brumm.de
___
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
___
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
