Date customfields and searching

RT Users
1

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

2

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

MartinOn 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

3

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 jvdwege@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.