[rt-users] Search old tickets from within scrip

[Keith Edmunds]

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.

Thanks,
Keith