RT 3.2.2 Query Builder question

What is the difference between ‘Updated’ and ‘Last Updated’?

When I run a query with ‘Updated = TODAY’ I get 43 results.

When I run a query with ‘LastUpdated = TODAY’ I get 84
results but none of them show up on the results page.

Weird.

What is the difference between ‘Updated’ and ‘Last Updated’?

When I run a query with ‘Updated = TODAY’ I get 43 results.

It’s unclear to me that Updated should even be an option.

When I run a query with ‘Updated = TODAY’ I get 43 results.

It’s unclear to me that Updated should even be an option.

The right way to debug this is to turn on database query logging and
see what RT’s generating.

I don’t ever use it, but I have “Updated” and “LastUpdated” (under Created,
Started, Resolved, etc) on our 99.99% vanilla RT 3.2.2.

-jdOn Fri, 8 Oct 2004, Jesse Vincent wrote:

On Fri, Oct 08, 2004 at 03:01:39PM -0400, Todd Chapman wrote:

What is the difference between ‘Updated’ and ‘Last Updated’?

When I run a query with ‘Updated = TODAY’ I get 43 results.

It’s unclear to me that Updated should even be an option.

When I run a query with ‘LastUpdated = TODAY’ I get 84
results but none of them show up on the results page.

Weird.


The rt-users Archives

Be sure to check out the RT wiki at http://wiki.bestpractical.com


The rt-users Archives

Be sure to check out the RT wiki at http://wiki.bestpractical.com

I don’t ever use it, but I have “Updated” and “LastUpdated” (under Created,
Started, Resolved, etc) on our 99.99% vanilla RT 3.2.2.

Sorry. I wasn’t suggesting that it’s a local issue.