Hi everyone, Someone can help me to sql query a custom field from RT.
select tickets.EFFECTIVEID, users.REALNAME, tickets.STATUS, TO_CHAR(tickets.DUE, 'YYYY/MM/DD'), tickets.SUBJECT from tickets, users where users.NAME = 'felipe' AND tickets.OWNER = 22 AND tickets.STATUS = 'resolved' order by tickets.EFFECTIVEID desc I need to display a custom field I name: "Modtrak" and "Requestor" Would any one help on this please. Thank you, -David -- RT Training - Boston, September 9-10 http://bestpractical.com/training