Asif,
> mysql> select TimeTaken from Transactions where id = 7391416;
>
> mysql> select TimeWorked from Tickets where id = 1188802;
>
> Transaction 7391416 is part of the Ticket 1188802 where the time
> worked was 15 mins.
>
> What gives?
>
> Using RT 3.8.2 with mysql 5.0.75
It depends on
That's twice in as many days. Time to tweak my aliases I think.
Sorry.
Stuart J. Browne
Senior Unix Administrator, Network Administrator, Database Administrator
AusRegistry Pty Ltd
Level 8, 10 Queens Road
Melbourne. Victoria. Australia. 3004.
Ph: +61 3 9866 3710
Fax: +61 3 9866 1970
Email: stua
Sorry about that, sent to the wrong local alias..
Stuart J. Browne
Senior Unix Administrator, Network Administrator, Database Administrator
AusRegistry Pty Ltd
Level 8, 10 Queens Road
Melbourne. Victoria. Australia. 3004.
Ph: +61 3 9866 3710
Fax: +61 3 9866 1970
Email: stuart.bro...@ausregistry.c
-Original Message-
From: Red Hat Support [mailto:supp...@redhat.com]
Sent: Tuesday, 26 June 2012 9:45 PM
To: Stuart Browne
Subject: (Waiting on Customer) Case #00666204 (RHN TRACEBACK generated)
ref:00DA000HxWHMA0.500A00A5zZcIAJ:ref
Hi,
If it's a single value selected in the custom field, we generally use something
like:
SELECT
...
PA.Content,
...
FROM
Tickets T
JOIN Users U ON T.Owner = U.id
JOIN Queues Q ON T.Queue = Q.id
LEFT OUTER JOIN (SELECT ObjectId, Content FROM ObjectCustomFieldValues
WHERE
> -Original Message-
> From: ruslan.zaki...@gmail.com [mailto:ruslan.zaki...@gmail.com]
> Sent: Wednesday, 13 June 2012 12:31 AM
> Subject: Re: [rt-users] TicketSQL Date parse weird..
>
> Hello Stuart,
>
> I've made a typo in the patch. It should be "ZONE" instead of "GMT".
> You can chan
> >
> >
> > Using either 'user' or 'server' as the timezone I get the same result
> but I'm probably missing something here for the fixed-date (I can accept
> that the date might be being modified elsewhere I'm yet to find), but the
> 'tomrorow 10am' shouldn't be a full day off. So the adding of
se weird..
>
> On Tue, Jun 05, 2012 at 06:06:09PM +1000, Stuart Browne wrote:
> > When doing a TicketSQL search similar to the following:
>
> RT actually passes a number of arguments to parsedate:
>
> grep can find where it's called (not in SQL.pm)
>
&g
Hi,
Using RHEL5, RT 3.8.8, Time::DateParse 2006.0814.
When doing a TicketSQL search similar to the following:
Status = 'open' AND Due <= '10am tomorrow'
The time portion of the string isn't taken into account.
On the command line, a quick test of Time::DateParse shows it works:
]# per
r any pointers?
Regards, Jim
On Mon, Nov 7, 2011 at 12:45 AM, Stuart Browne
mailto:stuart.bro...@ausregistry.com.au>>
wrote:
That would probably be in Principals, with the 'Disabled' field set to '0'.
That being said, you should probably use the API to create users e
That would probably be in Principals, with the 'Disabled' field set to '0'.
That being said, you should probably use the API to create users en-masse. It
would avoid minor problems like this.
Stuart
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.co
> -Original Message-
> Sent: Friday, 2 September 2011 10:26 AM
>
> On Fri, Sep 02, 2011 at 09:45:28AM +1000, Stuart Browne wrote:
> > The documentation is fairly vague on custom callbacks. Thanks to
> http://www.runpcrun.com/node/272 for the clue as to where the cus
Damn, missed the path properly:
---
/opt/rt3/local/html/Callbacks/MingleCardNumberLink/Elements/ShowCustomFields/ShowComponentName
<%INIT>
if ($CustomField->Name eq 'Mingle Card Number') {
$$Name = 'DisplayMingleCardLink';
}
<%ARGS>
$Name => undef
$CustomField => undef
$Object => undef
> > On Thu, Sep 01, 2011 at 12:05:57PM +1000, Stuart Browne wrote:
> > > > I'd just do a custom display of that Custom Field and build the link
> > > > myself, rather than trying to extend the link to functionality.
> > > >
> > > >
to - use multiple CF values
>
> On Thu, Sep 01, 2011 at 12:05:57PM +1000, Stuart Browne wrote:
> > > I'd just do a custom display of that Custom Field and build the link
> > > myself, rather than trying to extend the link to functionality.
> > >
> >
> I'd just do a custom display of that Custom Field and build the link
> myself, rather than trying to extend the link to functionality.
>
> You'll probably find the ShowComponentName callback useful
Kevin,
Thanks for the suggestion.
This is what I ended up with.
/opt/rt3/local/html/Callbacks/
> > Hi,
> >
> > I'm using the perl module 'RT::Client::REST' to query the database for
> > tickets with a specific custom field with a value and update the tickets
> > to a different owner and state.
> >
> > Script works for 2 other queues without issue. The 3rd queue however,
> > configured the s
> -Original Message-
> From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
> boun...@lists.bestpractical.com] On Behalf Of Stuart Browne
> Sent: Tuesday, 30 August 2011 5:09 PM
> To: rt-users@lists.bestpractical.com
> Subject: [rt-users] REST interface, get
Hi,
I was wondering if anybody knew of any extensions that could create a link from
more than one custom fields combined together.
Situation:
I have a custom field with a mingle card number. Link-to value works fine for a
single mingle project, project name is in the path. Sadly, the card num
Hi,
I'm using the perl module 'RT::Client::REST' to query the database for tickets
with a specific custom field with a value and update the tickets to a different
owner and state.
Script works for 2 other queues without issue. The 3rd queue however,
configured the same as far as I can see, be
I don't suppose you could throw that up onto the wiki so people don't have to
hunt it down through the mailing list archives? :)
*copies locally to implement later*
> -Original Message-
> From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
> boun...@lists.bestpractical.com]
Doesn't that miss if someone just changes the TimeWorked value on the Basic tab
of the ticket?
I use (in MySQL SQL):
SUM(IF(Field = 'TimeWorked', NewValue - OldValue, TimeTaken)) as TimeWorked
> -Original Message-
> From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
> boun
> > CPAN makes me cranky, but trying to package all the perl modules as RPMs
> > makes me crankier. It's like wrapping one packaging system around
> another
> > one, and fighting with both of them.
I've done this quite successfully. I've got RH distributed perl + packages
plus those that I've ma
> -Original Message-
> From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
> boun...@lists.bestpractical.com] On Behalf Of Jeff Blaine
> Sent: Friday, 5 November 2010 1:16 AM
> To: rt-users@lists.bestpractical.com
> Subject: [rt-users] Hardware requirements / guidelines?
>
> W
Applied, tested. Beautiful.
Thank you Ruslan.
> -Original Message-
> From: ruslan.zaki...@gmail.com [mailto:ruslan.zaki...@gmail.com] On
> Behalf Of Ruslan Zakirov
> Sent: Tuesday, 19 October 2010 23:05
> To: Stuart Browne
> Cc: rt-users@lists.bestpractical.com
> S
Hi,
Running RT 3.8.8 / DBIx::SearchBuilder 1.56, and have noticed some strange
behaviour with the 'Show Results' link and the Query Builder.
>From the 'At A Glance' page, I generally click on 'xx highest priority tickets
>I own' to bring up the search result, then click 'Edit Search' and add
>
Hi,
Am trying to do a select-a-worded-priority for our interface and have set the
sort order to the numeric priority values, but I can't figure out how to get
the sort order from a Scrip on the queue so I can set the ticket's Priority
($ticket->SetPriority(xxx)).
Is there a way using ObjectCus
> -Original Message-
> From: slamp slamp
> Sent: Tuesday, 11 May 2010 04:19
>
> For example:
>
> From rt.domA.com to rt.domB.com.
>
> From supp...@doma.com to supp...@domb.com
>
> During the transition, we would still like to support rt.domA.com via
> a redirecto rt.domB.com (apache). A
> -Original Message-
> From: Michael Ellis
>
> Does anyone know of a browser setting that could explain why one user
> is prompted to authenticate for new tabs within the RT system? This
> does not happen every time, but enough to be annoying. RT is set to
> expire sessions after 8 hours.
> From: badreddine meherzi
>
> I'm new on RT and I want to write a perl script that creates
> a ticket in RT, so how can I proceed, wich are the Perl modules
> that I have to install and is there an example of Perl script
> creating an RT ticket(that would helps me a lot).
This is parts scraped fr
This is a re-send as no response in the week it was posted.
--
Hi,
I've got some custom fields for 3-point time estimates on project tickets.
I've got it so that upon creation / update of the custom field, the
'TimeEstimated' f
> -Original Message-
> From: stefan.rueetsc...@securiton.ch
>
> I'd like to quick-search also on fixed/resolved tickets.
>
> -Ursprüngliche Nachricht-
> Von: Renato S. Yamane
>
> On start page I can see a Quick Search pannel, but it have only 3 kind
> of status (New, Open and Sta
Hi,
I've got some custom fields for 3-point time estimates on project tickets.
I've got it so that upon creation / update of the custom field, the
'TimeEstimated' field gets set to the 'Most Likely' custom field value. I've
also got it so that it ignores any changes made manually to the 'Time
> -Original Message-
> From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
> boun...@lists.bestpractical.com] On Behalf Of Matt Adams
> Sent: Tuesday, 12 January 2010 16:44
> To: rt-users@lists.bestpractical.com
> Subject: [rt-users] Custom field textarea too small
>
> Folks:
> -Original Message-
> From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
> boun...@lists.bestpractical.com] On Behalf Of Tom Lahti
> Sent: Wednesday, 25 November 2009 10:55
> To: Ivan Voras
> Cc: rt-users
> Subject: Re: [rt-users] Is SQLite no longer supported?
>
> > Sligh
> -Original Message-
> From: Barron, Josh
>
> That file does not exist in the new RT directory, nor is any file by
> that name in use anywhere from what I can see.
>
> I'm really baffled by this.
SELinux isn't turned on by any chance is it?
getenforce
ausearch -m avc -ts
Hi,
I'm trying to get the CLI 'rt' tool to create a ticket with a specified owner.
I'm trying:
/opt/rt3/bin/rt create -t ticket set status=new
owner="stuart.bro...@ausregistry.com.au" subject="`date +'General Tasks %Y%m -
%W'`" queue="au Maintenance" text="Auto-created weekly general
Publicly faced:
Web server : 22:05:01 up 566 days, 10:38, 0 users, load average: 0.04, 0.03,
0.02
Mail server: 09:04:10 up 573 days, 15:16, 0 users, load average: 0.16, 0.04,
0.01
Name server: 22:04:16 up 573 days, 21:34, 0 users, load average: 0.02, 0.05,
0.00
RHEL5.
Simplicity isn't al
I sent this through a while ago, but got no responses.
Anybody know what can help with this slow 'Search page' coming up issue?
I've since seen a few other people mention the issue, but no response there
either..
Anybody?
Stuart
-Original Message-----
From: Stuart Browne
It would be possible to have your own perl installed into its own structure,
with all its own localized modules, with its own library path pointing to where
it was installed.
What would be difficult with a canned install however would be the web server
configuration required / mod_perl stuff.
Hi,
After doing a 3.8.1 upgrade (install into new directory, upgrade db from
3.6.5), clicking on 'Tickets' / 'New Search' causes a 10-15 second pause.
Digging through the active queries when that occurs shows the following query:
SELECT DISTINCT main.* FROM Users main CROSS JOIN ACL ACL_4 JOIN
Hi,
I'm trying to tie a specific custom field down to being modified only by a
specific user, but can't figure out how to find out what user is actually
logged in doing the action.
Whenever I use $self->CurrentUser, it shows 'RT_System' instead of the user I'm
logged in as, and the person isn'
Anybody know why it has a gaming log by 'harry1999' as its front page?
Stuart J. Browne
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover
43 matches
Mail list logo