robert at robertblackwell
Sep 13, 2012, 9:53 AM
Post #3 of 4
This works great!
Re: Searching for a tickets with a filename
[In reply to]
Is this a supported field in simple search?
On Thu, Sep 13, 2012 at 12:37 PM, Thomas Sibley <trs [at] bestpractical> wrote:
> 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
> We're hiring! http://bestpractical.com/jobs
Final RT training for 2012 in Atlanta, GA - October 23 & 24
We're hiring! http://bestpractical.com/jobs