[rt-users] sql custom fields query display

support at pureview.com support at pureview.com
Tue Aug 12 22:32:29 EDT 2014

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,

More information about the rt-users mailing list