[rt-users] Finding tickets based on changed field

Kenneth Crocker kfcrocker at lbl.gov
Mon Apr 11 14:16:35 EDT 2011


Vance,

I don't think you can do that with standard RT-SQL. I would imagine you
could do it directly from the DB via SQL by looking at the "LastUpdated"
date field of the OBJECTCUSTOMFIELDVALUES table.

Kenn
LBNL

On Mon, Apr 11, 2011 at 6:32 AM, Vance Walsh <vance_walsh at concordacademy.org
> wrote:

>  Is there a method to find all tickets which have had a custom field
> edited/changed in the last 30 days?
>
> ---
>
> Vance Walsh
> Network and Systems Administrator
> Concord Academy - Concord, Mass.
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110411/5eddaf95/attachment.htm>


More information about the rt-users mailing list