[rt-users] unable to form query in TicketSQL; can RT do SQL?

Robert Kleemann kleemann at scharp.org
Sun Aug 12 15:02:26 EDT 2007

I'm trying to do the query "show me any tickets that I've touched in any 
way in the past three weeks." I've tried to use the query ui and 
TicketSQL but couldn't find a query that worked.

I have access to the postgres DB that runs our RT system so I was able 
to form the following SQL query that works:

select distinct foo.id, tickets.subject from (
  select  transactions.objectid, transactions.created, tickets.id
  from transactions, tickets
  transactions.creator=(select users.id from users where name='kleemann')
  and objecttype='RT::Ticket'
  and transactions.created > (now()- interval '3 weeks')
  and transactions.objectid = tickets.id
) as foo, tickets
where foo.id=tickets.id

I'd like to have the query results available in RT so I could have a 
list of ticket links. Is there a way to make RT use a query like this? 
Is there an easier way to do this?


More information about the rt-users mailing list