[rt-users] Date customfields and searching

2013-02-11 Thread Joop
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

2013-02-11 Thread Martin Wheldon

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] Date customfields and searching

2013-02-11 Thread Ruslan Zakirov
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 jvdw...@xs4all.nl 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