[mailto:firstname.lastname@example.org] On Behalf
Of Alex Strachan
Sent: Tuesday, April 11, 2006 9:31 PM
Subject: [rt-users] TicketSQL,QueryBuilder search
construction for returning ticketid’s which don’t have a
TicketSQL question when searching on Requestor.Name. I have
Wiki and the RT book but been unable to construct a TicketSQL
return my requirements.
The QueryBuilder shows the same result set. Is it something
to do with
OS: RHES4, RT: 3.4.5
Requestors: ReqA, ReqB
rt list -i “Requestor.Name != ‘ReqB’”
What is the TicketSQL construct that would return ticket/101 only ?
Using LIKE, NOT LIKE I’m still unable to return the single ticket.
It has to do with how the schema is set up. I ran into the same
problem, and unfortunately, there doesn’t appear to be a solution other
than refactoring the DB schema. In fact, I filed a bug for this:
http://rt3.fsck.com/Ticket/Display.html?id=7197. You’ll see the kind of
queries I am trying to do there. It wasn’t working in any of the 3.4.x
or 3.5.x code. I had thought that something like doing a UNION
somewhere in the query might be the solution, but I hadn’t sat down to
think it through. The problem is getting that into the searchbuilder