On 29/02/2008, at 1:18 PM, Tom Lanyon wrote:
> Hi List,
>
> Can I add a clause to my Ticket SQL query to say "has a dependancy" ?
>
> I am searching for tickets but do not want to return ones that depend
> on another.
>
> Thanks,
> Tom
I've tried "Queue = 'General' AND HasMember IS NOT NULL" as i
You could do that pretty easily with a basic SQL query...
select
objectid as ticket,
date_trunc('month', created) as month,
sum(cast(newvalue as int) - cast(oldvalue as int)) as timeworked
from transactions where
field = 'TimeWorked' and type = 'Set'
and objecttype = 'RT::
Hi List,
Can I add a clause to my Ticket SQL query to say "has a dependancy" ?
I am searching for tickets but do not want to return ones that depend
on another.
Thanks,
Tom
--
Tom Lanyon
Systems Administrator
NetSpot Pty Ltd
___
http://lists.bestp
I run some python scripts which extract the time per task per user per
day which are then imported into a slightly modded sql-ledger which
then produces an invoice for the client with an accompanying activity
report.
-- Forwarded message --
From: John Arends <[EMAIL PROTECTED]>
Dat
John,
No, but I've thought about it. Trouble is, RT doesn't separate time
between intervals. Time worked is simply added, which means you cannot
tell how much time belongs in the last month, or whatever. You would
have to define your own table in the DataBase with the kind of data
deli
On Thu, 2008-02-28 at 16:12 -0600, John Arends wrote:
> I'm curious if anyone has used RT for job billing? It's pretty easy to
> record the time for each task you perform but there really isn't a good
> mechanism for generating a bill to send to a client.
>
> Has anyone tried anything like that?
On Thu, Feb 28, 2008 at 9:14 PM, Kenneth Crocker <[EMAIL PROTECTED]> wrote:
> Shannon,
>
>
> Your code doesn't make any sense to me. You use "A" for the
> Attachments
> table and "T" for the Transactions table. But when you refer to the
> field in your code you wrote "T.Ticket". There is
I'm curious if anyone has used RT for job billing? It's pretty easy to
record the time for each task you perform but there really isn't a good
mechanism for generating a bill to send to a client.
Has anyone tried anything like that?
___
http://lists.be
Thank you
Todd Chapman wrote:
>
> You can remove them from the At A Glance page by going into:
>
> Configuration -> Global -> RT at a glance
>
> Then copy
>
> Set($HomepageComponents, [qw(QuickCreate Quicksearch MyAdminQueues
> MySupportQueues MyReminders RefreshHomepage)]);
>
> from RT_Co
It sounds like something that could be done with the rt
commandline tool or a perl script using the RT API.
Cheers,
Ken
On Thu, Feb 28, 2008 at 07:09:42PM -, Stef Morrell wrote:
> Hi,
>
> I've been back over the lists and I can't find any reference to this, so
> I'm probably asking a stupid
Hi,
I've been back over the lists and I can't find any reference to this, so
I'm probably asking a stupid question.
I'm in the process of setting up RT as a replacement to an old (largely
broken) in-house ticketing system, coded by a long since gone employee,
but I've hit a stumbling block.
I ne
Todd,
If you handle each customer/company as an entity with it's own list of
Privileged Requestors (preferably in a group), then it wouldn't be any
different than an RT session that handles requests from different
organizations/departments within a company/session. We have different
o
Shannon,
Your code doesn't make any sense to me. You use "A" for the Attachments
table and "T" for the Transactions table. But when you refer to the
field in your code you wrote "T.Ticket". There is no "Ticket" field on
the Transaction table. That's probably why you got the error.
This is the method we use. As an organization with an ever growing customer
roster it makes more sense for us to keep our queues limited to internal
departments. We have a custom field which we use to determine the customer to
which a ticket "belongs".
Mathew
Roy El-Hames wrote:
> My take on th
On 28 Feb 2008, at 15:13, Todd Rittinger wrote:
>
> Hello Everyone!
Hello :)
> I have a question regarding deploying RT. Currently we use individual
> queues for our product line, internal support, and interdept.
> requests.
> This keeps the queue list to a manageable amount. I was curious i
Update on this. I found some old posts and I am trying to use the following
command to display tickets by size:
mysql -u root -p -hlocalhost rt3 -e'select length(A.Content), A.id,
T.Ticket fromAttachments A, Transactions T where A.TransactionId = T.id order
by 1'
it returns:
"ERROR 1054 (42S
My take on this is, why have a queue per customer when you can have a
group per customer ..
After all customers are only a group of requesters ..
In the set up I have here we I Queues to represent departments and hence
escalations is as simple as changing ticket queue etc ..
Regards;
Roy
Todd R
Hello Everyone!
First off, excellent list! I've been a lurker on here for about a year
now and some great information and discussions abound, thank-you all!
I have a question regarding deploying RT. Currently we use individual
queues for our product line, internal support, and interdept. request
Once in a while, I use rtx-shredder to purge tickets older than a month that
are marked as deleted.
rtx-shredder --plugin "Tickets=limit,5000;status,deleted;updated_before,`date
-I -d '1 month ago'`" --force
We have some very old tickets that contain attachments that I would like to
purge. Fi
Agreed :¬)
I could n't think of any other header lines to demonstrate the point.
Roy
Kenneth Crocker wrote:
> Roy,
>
>
> I'm not sure the "RT-Attach-Message: Yes" line is necessary. If he
> just wants to send a comment and ticket info, I don't think he needs
> that line.
>
>
> Kenn
> LBNL
>
Aha!
Found the problem - it's a total schoolboy error. Checking syslog netted
me a "No recipients found. Not sending." line, and I'd missed the fact
that the executor of an action doesn't get included in the e-mail
distribution.
Apologies, and many thanks for your efforts, Roy & Kenn!
S.
-O
Thanks for the thoughts so far, guys - unfortunately it doesn't seem to
have made any difference! I've also tried changing from a group as the
AdminCC to a user, but that didn't work. Then I tried building a scrip
on the destination queue rather than keeping it at global level, and
that's not playi
22 matches
Mail list logo