Searching CF Date field using relative (ie: now + Days)

Many hours later, I cannot seem to get this working…

I am running RT 3.6.5, SUSE 10 , lighttpd, https configuration
with the patch for date customfields
upgraded to the latest DBIx::SearchBuilder 1.51 ( was at 1.48) .

Also have same issue with my 3.6.3 Redhat http configuration
without the patch for date customfields.

The relative searching works as expected if I use the standard DUE, LastUpdated , Resolved etc fields,
but not if I use a CF date field.

example : the relational syntax
Due < ’ +5 Days’ works if I use the standard Due field,

but not if I use a CF field …
‘CF.{Ready Date}’ < ‘+5 Days’ this returns 0 hits.,

but if I use the actual date…

‘CF.{Ready Date}’ < ‘2008-02-14’ this works…

I am afraid now that I have been staring too long ,and may be missing the obvious…

Any suggestions where I should be focusing on to untangle myself here ?
Anybody have this working with a similar install…

PS: Thanks Emmanuel for you help so far…
Tired, and bleary eyed…

it’s never been working for CFs, only for standard ticket’s dates.On Feb 10, 2008 6:23 AM, Roy Sowa Roy.Sowa@rcmp-grc.gc.ca wrote:

Many hours later, I cannot seem to get this working…

I am running RT 3.6.5, SUSE 10 , lighttpd, https configuration
with the patch for date customfields
upgraded to the latest DBIx::SearchBuilder 1.51 ( was at 1.48) .

Also have same issue with my 3.6.3 Redhat http configuration
without the patch for date customfields.

The relative searching works as expected if I use the standard DUE, LastUpdated , Resolved etc fields,
but not if I use a CF date field.

example : the relational syntax
Due < ’ +5 Days’ works if I use the standard Due field,

but not if I use a CF field …
‘CF.{Ready Date}’ < ‘+5 Days’ this returns 0 hits.,

but if I use the actual date…

‘CF.{Ready Date}’ < ‘2008-02-14’ this works…

I am afraid now that I have been staring too long ,and may be missing the obvious…

Any suggestions where I should be focusing on to untangle myself here ?
Anybody have this working with a similar install…

PS: Thanks Emmanuel for you help so far…
Tired, and bleary eyed…


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

it’s never been working for CFs, only for standard ticket’s dates.

I thought my patch was enough, but not. I think it requires also to
patch the DB schema and some other CF libs to add DATETIME field for
ObjectCustomFieldValues (there is already Content and LargeContent, we
need something like DateContent).

@jesse, do you have plan for date customfields in 3.8 ? If so I’m ok to
try to continue working on it, but if not, I will stop here because this
would be a too intrusive patch to maintain…

I havn’t seen the patch.On Feb 10, 2008 10:40 AM, Emmanuel Lacour elacour@easter-eggs.com wrote:

On Sun, Feb 10, 2008 at 08:52:01AM +0300, Ruslan Zakirov wrote:

it’s never been working for CFs, only for standard ticket’s dates.

I thought my patch was enough, but not. I think it requires also to
patch the DB schema and some other CF libs to add DATETIME field for
ObjectCustomFieldValues (there is already Content and LargeContent, we
need something like DateContent).

@jesse, do you have plan for date customfields in 3.8 ? If so I’m ok to
try to continue working on it, but if not, I will stop here because this
would be a too intrusive patch to maintain…


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

I havn’t seen the patch.

http://rt3.fsck.com/Ticket/Display.html?id=8721