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 _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
