[rt-users] Search old tickets from within scrip

Keith Edmunds kae at midnighthax.com
Tue Aug 7 17:59:14 EDT 2007

RT 3.6.1

We have one custom field per ticket, "Customer", of type 'select one
value'. So far, we've set that value manually on each new ticket, but I'd
like to automate it.

What I'd like to do, within a script, is search for the last ticket from
this requestor and set the customer custom field to the same value. In
pseudo SQL terms: "select customer from custom_fields where
requestor_address = '$requestor' and customer != null order id desc limit
1". How can I do that kind of search from a script? I'm not looking for
in-depth instructions, just a pointer as to the best way of doing this.


More information about the rt-users mailing list