On 09/06/2012 07:07 AM, Robert Blackwell wrote:
> Here is the SQL and stack trace of two queries obtained by using
> "Configuration » Tools » SQL Queries".
>
[snip]
> ObjectCustomFieldValues_1.Content < 'today'
Er, right. I forgot that date and datetime CFs don't get the same
"natural language"
On Fri, Aug 24, 2012 at 12:59 PM, Thomas Sibley wrote:
> On 08/24/2012 09:35 AM, Robert Blackwell wrote:
>> For example I would expect these to return the same tickets but they don't:
>>
>> This returns 7 tickets.
>> Status != 'resolved' AND CF.{FollowUp} < '2012-08-25'
>>
>> This returns 513.
>>
On 08/24/2012 09:35 AM, Robert Blackwell wrote:
> For example I would expect these to return the same tickets but they don't:
>
> This returns 7 tickets.
> Status != 'resolved' AND CF.{FollowUp} < '2012-08-25'
>
> This returns 513.
> Status != 'resolved' AND CF.{FollowUp} < 'tomorrow'
Capture th
Hello,
We have a global custom field of Type 'select date' (not datetime)
called FollowUp.
When trying to query tickets using the Advanced tab and TicketSQL
using the word 'today' as described on this page,
http://requesttracker.wikia.com/wiki/TicketSQL, we are not getting the
same results as exp