Ruslan,
Would this be the correct code:
Comment = {
title = 'Comment', # last comment
attribute = 'Comment',
value = sub { return $_[0]-TransObj-Id( $_[0]-id
)-Field('Type')-Value('Comment') }
},
Thanks.
Kenn
LBNL
On Sun, Dec 12, 2010 at 6:13 AM,
Hi,
If you mean search results and thier format strings then there is no
such column map, but it's possible to add. Look at
share/html/Elements/RT__Ticket/ColumnMap.
On Sat, Dec 11, 2010 at 1:44 AM, Kenneth Crocker kfcroc...@lbl.gov wrote:
To List,
Does anyone know how to get the last comment
To List,
Does anyone know how to get the last comment on a ticket to display in a
Query? I can get it in a template, but it doesn't seem available in a Query.
Kenn
LBNL
-boun...@lists.bestpractical.com] On Behalf Of Kenneth Crocker
Sent: 15 October 2010 20:59
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT Query not allowing any Custom Field selection
Raed,
That did it. Where did you find that? I don't remember any instructions on
having to use
...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kenneth Crocker
Sent: 15 October 2010 00:40
To: rt-users@lists.bestpractical.com
Subject: [rt-users] RT Query not allowing any Custom Field selection
To List,
I'm getting a wierd result when trying to create a search looking
-users-boun...@lists.bestpractical.com] *On Behalf Of *Kenneth Crocker
*Sent:* 15 October 2010 00:40
*To:* rt-users@lists.bestpractical.com
*Subject:* [rt-users] RT Query not allowing any Custom Field selection
To List,
I'm getting a wierd result when trying to create a search looking
@lists.bestpractical.com
Subject: Re: [rt-users] RT Query not allowing any Custom Field selection
Raed,
Just keep it up guy, and I'm gonna end up owing you an entire brewery. ;-).
This is what is in Advance:
( Queue = 'DS-BRS' OR Queue = 'DS-Development' ) AND CF.{DS-SubjectArea} =
'Expense'
and it won't let
:* 15 October 2010 17:15
*To:* rt-users@lists.bestpractical.com
*Subject:* Re: [rt-users] RT Query not allowing any Custom Field selection
Raed,
Just keep it up guy, and I'm gonna end up owing you an entire brewery. ;-).
This is what is in Advance:
( Queue = 'DS-BRS' OR Queue = 'DS
To List,
I'm getting a wierd result when trying to create a search looking for a
certain value in a Custom Field that is applied to a couple Queues.
I check the Queues and add them, no problem. I check the Custom Field and
add it and I am immediately thrown into *Advanced*. Every change I make
To list,
In 3.6.4, whenever I selected a queue from QuickSearch list, it would
show the active tickets in that queue. From there, I could select a
ticket number in that list and it would take me directly to that ticket
display. I can no longer select a ticket from that list. Am I missing a
To all,
I want to modify the way dates are displayed when I run a query,
especially since I want to download the info to a spreadsheet. I just
want the date, no time, no day-of-week, etc. I just want it to show
dd/mm/. Is there some way to do this in advanced or some way to
select it
To List,
Whenever I create a query and want to include the Requestor(s), I always
get the email address, ie. kfcroc...@lbl.gov. What I want is the name
only, KFCrocker. In the advanced section, I see this code
__Requestors__. What can I change that to to just get the requestors name?
Thanks.
Varun Vyas wrote:
Hello All
Can anyone can tell me how i can log my queries that hits my database in
RT.log. I am using oracle 9i and RT 3.6.3 we have a performance issue as
I saw that it is now working for you, query logging that is.
our RT is very slow and takes 15-20 seconds for
: Re: [rt-users] RT Query Logging
Varun Vyas wrote:
Hello All
Can anyone can tell me how i can log my queries that hits my database in
RT.log. I am using oracle 9i and RT 3.6.3 we have a performance issue as
I saw that it is now working for you, query logging that is.
our RT is very slow
Hello All
Can anyone can tell me how i can log my queries that hits my database in
RT.log. I am using oracle 9i and RT 3.6.3 we have a performance issue as
our RT is very slow and takes 15-20 seconds for database operations. So
i want to log my queries so that i can then analyze them for
From RT_Config.pm
# DBIx-SearchBuilder 1.31_1 or higher; simply set $StatementLog to be
# the level that you wish SQL statements to be logged at.
Set($StatementLog,undef);
I am not sure what the different levels but :
Set($StatementLog,1);
will be a good start.
Remember to restart your web
Varun;
There is no straight forward answer to this , you possibly should start
by stating your RT version, DB type(oracle,mysql ??) and version ,
apache, mod_perl or fastcgi etc ..
Also search the wiki and mailing list there are lots of posts and a good
article in the wiki covering
Varun;
You should make it a habit to reply to the list and not individuals , I
have never deployed RT with Oracle so can't help you --
few in the may though
ps: A pointer so you know what RT is capable of , our RT db is 50G in
size, the attachments table alone is 26G, our db server is quad
And can you can tell me what kind of maintainance you have done on
application side i.e RT side to enhance its performance and what kind of
tweaks you have applied in apache configuration file and
RT_SiteConfig.pm file
Thanks In Advance
Raed El-Hames wrote:
Varun;
You should make it a
There is no bother, what I meant is the list will be more helpful than me.
for tweaks and performance tuning the wiki and mailing list is better
place than me, because it varies depending on the database server you use.
Start with observation and detect your bottle necks , ist the web part
or
On 4 Mar 2009, at 9:52 pm, Kenneth Crocker wrote:
To all Jesse,
I have wondered if it would be RT Query could be enhanced to allow
two
things:
1) The ability to search for Queues with the LIKE command.
Reason; I have several groups that have more than 15 queues (1
To all,
So far, I've been able to develop every kind of query/report my users
have asked for. Now someone wants a Query/report that would include the
comments (only. Not any email, etc.) in the results. I have not been
able to find that option in Query builder. Has anyone developed a
Ken-
I have customized the export report found in
'share/html/Search/Results.tsv'. I created a new file and added this
section to pull the last correspondence. You could easily change it to fit
comments:
# #
my $Transactions = $Ticket-Transactions;
$Transactions-Limit(
Matt,
THANKS! I'll take a look and see what I can do.
Kenn
LBNL
On 3/4/2009 12:00 PM, Matt Hoover wrote:
Ken-
I have customized the export report found in
'share/html/Search/Results.tsv'. I created a new file and added this
section to pull the last correspondence. You could
To all Jesse,
I have wondered if it would be RT Query could be enhanced to allow two
things:
1) The ability to search for Queues with the LIKE command.
Reason; I have several groups that have more than 15 queues (1 has 52
Queues) under their management. In order for
Sent: Thursday, March 27, 2008 3:13 PM
To: rt Users
Subject: [rt-users] RT Query - Ticket SQL
To all,
I don't believe I have seen any threads on this question, but if
so,
please forgive me. I just re-named a bunch of queues to include
To all,
I don't believe I have seen any threads on this question, but if so,
please forgive me. I just re-named a bunch of queues to include a prefix
so that if a particular group works with tickets in several queues, they
can create a query that asks for queues LIKE XX- instead of
Crocker
Sent: Thursday, March 27, 2008 3:13 PM
To: rt Users
Subject: [rt-users] RT Query - Ticket SQL
To all,
I don't believe I have seen any threads on this question, but if so,
please forgive me. I just re-named a bunch of queues to include a prefix
so that if a particular group
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kenneth
Crocker
Sent: Thursday, March 27, 2008 3:13 PM
To: rt Users
Subject: [rt-users] RT Query - Ticket SQL
To all,
I don't believe I have seen any threads on this question, but if so
: Thursday, March 27, 2008 3:13 PM
To: rt Users
Subject: [rt-users] RT Query - Ticket SQL
To all,
I don't believe I have seen any threads on this question, but if so,
please forgive me. I just re-named a bunch of queues to include a prefix
so that if a particular
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kenneth
Crocker
Sent: Thursday, March 27, 2008 3:13 PM
To: rt Users
Subject: [rt-users] RT Query - Ticket SQL
To all,
I don't believe I have seen any threads on this question
:[EMAIL PROTECTED] On Behalf
Of Ruslan Zakirov
Sent: Wednesday, June 27, 2007 3:34 PM
To: [EMAIL PROTECTED]
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT Query builder slow
you're using mysql 5.x or you granted OwnTicket right to too many users.
Which one
PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Ruslan Zakirov
Sent: Wednesday, June 27, 2007 3:34 PM
To: [EMAIL PROTECTED]
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT Query builder slow
you're using mysql 5.x or you granted OwnTicket right to too many users.
Which one?
--
Best
We have mysql 5.022 - can you let us know why that is a problem?
Mysql 5.x uses wrong order of joins for a query. We have no solution
on RT side. I tried to fix this problem several times, but now I
think we have to file bug into mysql bug tracker.
OK, thanks for the info, however see below
Hi
Our RT system is generally very fast, except for when you click on anything
that displays the Query Builder screen. Once Query Builder has loaded and
you click Add and Search, the search itself is fast to return the results
and display subsequent pages.
Some details of our system
you're using mysql 5.x or you granted OwnTicket right to too many
users. Which one?
On 6/27/07, Neil Turner [EMAIL PROTECTED] wrote:
Hi
Our RT system is generally very fast, except for when you click on anything
that displays the Query Builder screen. Once Query Builder has loaded and
you
36 matches
Mail list logo