[rt-users] Problem in searching date

[Chrilly Cheng]

Hi Alex,

Thanks for replying.

I found logs below, but no more details about it.

[Tue Sep  2 10:55:32 2014] [debug]: RT::Date used Time::ParseDate to make
'Sunday' 0 (/usr/share/request-tracker4/lib/RT/Date.pm:222)
[Tue Sep  2 10:55:32 2014] [debug]: RT::Date used Time::ParseDate to make
'last Sunday' 1409482532 (/usr/share/request-tracker4/lib/RT/Date.pm:222)
[Tue Sep  2 10:55:32 2014] [debug]: RT::Date used Time::ParseDate to make
'Sunday' 0 (/usr/share/request-tracker4/lib/RT/Date.pm:222)
[Tue Sep  2 10:55:32 2014] [debug]: RT::Date used Time::ParseDate to make
'last Sunday' 1409482532 (/usr/share/request-tracker4/lib/RT/Date.pm:222)

And thanks for your reminding, I'm also aware of this, but our manager
prefer that label, which is hard to config with the built-in attribute in
RT.


Br
Vodar


On Tue, Sep 2, 2014 at 6:35 PM, Alex Peters <alex at peters.net> wrote:

> What does the debug log say when you run the search?
>
> There are some config options relevant to relative dates, but it's worth
> verifying first that the two dates are being parsed at all.
>
> P.S.  I believe that the built-in Starts ticket attribute is intended to
> function as a proposed start time.
> On 02/09/2014 8:25 pm, "Chrilly Cheng" <chrilde at gmail.com> wrote:
>
>> Do I need to do any setting of the week on server?
>>
>>
>> On Tue, Sep 2, 2014 at 3:59 PM, Chrilly Cheng <chrilde at gmail.com> wrote:
>>
>>> Hi Guys,
>>>
>>> I was trying to create a qeury which returns all open tickets whose
>>> "Proposed Start Date" are in this week, from specific queue. I tried with
>>> some build-in variables in searching as showing below:
>>>
>>> Queue = 'ChangeRequest' AND (  Status != 'rejected' AND Status !=
>>> 'resolved' ) AND 'CF.{Proposed Start Time}' > 'last Sunday' AND
>>> 'CF.{Proposed Start Time}' < 'Sunday'
>>>
>>> but this query returns nothing. BTW, "Proposed Start Time" is a
>>> datetime custom field applied to this queue.
>>>
>>> Can you please help to check on this, see whether it doesn't work? Many
>>> thanks.
>>>
>>>
>>> Br
>>> Vodar
>>>
>>>
>>>
>>
>> --
>> RT Training - Boston, September 9-10
>> http://bestpractical.com/training
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140902/0501fee0/attachment.htm>