[rt-users] Date customfields and searching
Hi All, As per the subject I'm a bit stupified because I really thought that I could add a (global ticket) date customfield and search on it using relative terms like 'today' but it doesn't work. If I use relative terms with things like 'Created' then I get the expected results. I turned on StatementLog and looked at the queries and see that for de latter one it constructs a > and < but for the former one it just searches LargeContent for 'today' I'm using RT-4.0.9 Thanks in advance, Joop -- Help improve RT by taking our user survey: https://www.surveymonkey.com/s/N23JW9T
Re: [rt-users] Date customfields and searching
Hi Joop, This functionality currently doesn't work in your version of RT. I know that there is a patch to fix this but has yet to make it into a release to the best of my knowlege. This is functionality I would like to see, however I have worked around it by writing a script that runs from cron on a daily basis and emails a report to the relevant users. Best Regards Martin On 2013-02-11 11:00, Joop wrote: Hi All, As per the subject I'm a bit stupified because I really thought that I could add a (global ticket) date customfield and search on it using relative terms like 'today' but it doesn't work. If I use relative terms with things like 'Created' then I get the expected results. I turned on StatementLog and looked at the queries and see that for de latter one it constructs a > and < but for the former one it just searches LargeContent for 'today' I'm using RT-4.0.9 Thanks in advance, Joop -- Help improve RT by taking our user survey: https://www.surveymonkey.com/s/N23JW9T
Re: [rt-users] Adding rights to default lifecycle
Hi, Many thanks everyone for your responces, I'll give it a go at the weekend. Best Regards Martin On 2013-02-10 19:28, Thomas Sibley wrote: On 02/10/2013 12:10 AM, Martin Wheldon wrote: Hi, To answer part of my own question I see the default life cycle can be found in RT_Config.pm. Looks like my best option may be to copy the default over to RT_SiteConfig.pm and modify it there? Yes. You may wish to lock down the ability to reject with a custom right. Read more about lifecycles here: http://bestpractical.com/rt/docs/latest/customizing/lifecycles.html http://bestpractical.com/rt/docs/latest/RT_Config.html#Lifecycles -- Help improve RT by taking our user survey: https://www.surveymonkey.com/s/N23JW9T
Re: [rt-users] Date customfields and searching
Hi, This functionality is in the repo, however a few more problems were spotted, so it is under development. Sunnavy worked on this and he knows better at which code branch you should look at to see if fixes work for you or not. On Mon, Feb 11, 2013 at 3:00 PM, Joop wrote: > Hi All, > > As per the subject I'm a bit stupified because I really thought that I > could add a (global ticket) date customfield and search on it using > relative terms like 'today' but it doesn't work. If I use relative terms > with things like 'Created' then I get the expected results. I turned on > StatementLog and looked at the queries and see that for de latter one it > constructs a > and < but for the former one it just searches LargeContent > for 'today' > > I'm using RT-4.0.9 > > Thanks in advance, > > Joop > > > > > -- > Help improve RT by taking our user survey: > https://www.surveymonkey.com/s/N23JW9T -- Best regards, Ruslan. -- Help improve RT by taking our user survey: https://www.surveymonkey.com/s/N23JW9T
[rt-users] TimeTaken shows 0 minutes instead of 15 mins
mysql> select TimeTaken from Transactions where id = 7391416; +---+ | TimeTaken | +---+ | 0 | +---+ mysql> select TimeWorked from Tickets where id = 1188802; ++ | TimeWorked | ++ | 15 | ++ 1 row in set (0.00 sec) 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 -- Asif Iqbal PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing? -- Help improve RT by taking our user survey: https://www.surveymonkey.com/s/N23JW9T
Re: [rt-users] TimeTaken shows 0 minutes instead of 15 mins
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 what actions were taken during the transaction. If time was entered during the ticket creation, the TimeTaken value is filled in. If a comment or such was entered and time was entered against the action, it is created as TimeWorked with an NewValue / TimeWorked. To work out how much time a given transaction took, you need to do some math, (MySQL SQL follows): SELECT SUM(Transactions.TimeTaken) + SUM( IF(Transactions.OldValue != Transactions.NewValue, Transactions.NewValue - Transactions.OldValue, 0) ) AS TimeWorked FROM Transactions WHERE Field = 'TimeWorked' AND ObjectType = 'RT::Ticket AND ObjectId = 1188802; Adds all the TimeTaken values to the differences in OldValue and NewValue on TimeWorked for a given ticket. Stuart -- Help improve RT by taking our user survey: https://www.surveymonkey.com/s/N23JW9T
[rt-users] [rt-announce] RT 3.8.16 Released
I'm happy to announce that RT 3.8.16, the latest maintenance release, is available for download. http://download.bestpractical.com/pub/rt/release/rt-3.8.16.tar.gz http://download.bestpractical.com/pub/rt/release/rt-3.8.16.tar.gz.sig SHA1 sums 9df5ed89d93d07d64ece8692cfb9e4a444ade01d rt-3.8.16.tar.gz 9d71bc7b65638af15179d8e9def60f55b5329d7c rt-3.8.16.tar.gz.sig Recent support for partitioned GnuPG emails introduced a deadlock situation for large QP/Base64 emails with GnuPG enabled. In addition, this release resolves a number of issues running the test suite on newer versions of perl. git log rt-3.8.15..rt-3.8.16 or visit https://github.com/bestpractical/rt/compare/rt-3.8.15...rt-3.8.16 pgpgZqU3W9Vam.pgp Description: PGP signature ___ rt-announce mailing list rt-annou...@lists.bestpractical.com http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-announce -- Help improve RT by taking our user survey: https://www.surveymonkey.com/s/N23JW9T
Re: [rt-users] TimeTaken shows 0 minutes instead of 15 mins
On Mon, Feb 11, 2013 at 10:59 PM, Asif Iqbal wrote: > mysql> select TimeTaken from Transactions where id = 7391416; > +---+ > | TimeTaken | > +---+ > | 0 | > +---+ > > mysql> select TimeWorked from Tickets where id = 1188802; > ++ > | TimeWorked | > ++ > | 15 | > ++ > 1 row in set (0.00 sec) > > > 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 There is a fix, but it gets into RT 4.2. > -- > Asif Iqbal > PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu > A: Because it messes up the order in which people normally read text. > Q: Why is top-posting such a bad thing? > > > -- > Help improve RT by taking our user survey: > https://www.surveymonkey.com/s/N23JW9T -- Best regards, Ruslan. -- Help improve RT by taking our user survey: https://www.surveymonkey.com/s/N23JW9T
Re: [rt-users] TimeTaken shows 0 minutes instead of 15 mins
On Mon, Feb 11, 2013 at 5:24 PM, Stuart Browne wrote: > 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 what actions were taken during the transaction. user went 'The Basics' box and changed the Worked: box value from `0' to `15' Ticket 1188802: TimeWorked changed from '0' to '15' > > If time was entered during the ticket creation, the TimeTaken value is filled > in. > > If a comment or such was entered and time was entered against the action, it > is created as TimeWorked with an NewValue / TimeWorked. > > To work out how much time a given transaction took, you need to do some math, > (MySQL SQL follows): > > SELECT > SUM(Transactions.TimeTaken) + SUM( > IF(Transactions.OldValue != Transactions.NewValue, > Transactions.NewValue - Transactions.OldValue, > 0) >) AS TimeWorked > FROM > Transactions > WHERE > Field = 'TimeWorked' > AND ObjectType = 'RT::Ticket > AND ObjectId = 1188802; > > Adds all the TimeTaken values to the differences in OldValue and NewValue on > TimeWorked for a given ticket. > > Stuart -- Asif Iqbal PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing? -- Help improve RT by taking our user survey: https://www.surveymonkey.com/s/N23JW9T
[rt-users] Printing Charts
Good Afternoon, I am running 4.0.5 on Ubuntu. After creating queries and going to the chart options. I cannot print the charts out, it is the title and the rest is a blank page in IE and Firefox. There are no errors in the apache logs and the charts appear fine. This is true of pie and bar charts. I have tried searching, but most info is about display being broken as well as printing. I am using the default template, with a change in color on css only. Does anyone have any ideas? April [image: Yelp!] *April Rosenberg* *e:* apr...@yelp.com *t:* 415.632.4020 <> -- Help improve RT by taking our user survey: https://www.surveymonkey.com/s/N23JW9T