On 09/13/2012 07:31 AM, Robert Blackwell wrote:
> I have a problem where I need to search for tickets by attached file name.
> I am doing this currently by doing a SQL search against the database.
>
> Is there a way to do this via the API that I am missing?
The Query Builder and hence TicketSQL support Filename:
Queue = 'rt3' and Filename LIKE '.patch' and Status != 'resolved'
for example. You use $tickets->FromSQL(...) for TicketSQL via the API.
You'll probably want to add an index against Filename if you can for
better performance, but EXPLAIN your queries to see if that's necessary
and how much it helps.
--------
Final RT training for 2012 in Atlanta, GA - October 23 & 24
http://bestpractical.com/training
We're hiring! http://bestpractical.com/jobs
