[Rt-devel] BUG: Search Builder link searching

[Todd Chapman]

On Tue, Dec 06, 2005 at 03:05:33PM -0500, Todd Chapman wrote:
> On Tue, Dec 06, 2005 at 02:13:01PM -0500, Jesse Vincent wrote:
> > 
> > 
> > 
> > On Tue, Dec 06, 2005 at 02:47:35PM -0500, Todd Chapman wrote:
> > > When building a search and choosing the "LinkedTo" link
> > > type all tickets are returned. This is 3.4.HEAD. Anyone else
> > > seee the same problem?
> > 
> > It'd help to know what the TicketSQL query it's generating is and
> > whether that query fails when it's run in the test suite
> 
> Of course. :)
> 
> Ticket SQL:
> 
>  LinkedTo = '2'
> 
> MySQL Query:
> 
> SELECT count(main.id) FROM Tickets main   WHERE ((main.EffectiveId = main.id)) AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket'))
> 
> In contrast
> 
> Ticket SQL:
> 
>  RefersTo = '2'
> 
> MySQL Query:
> 
> SELECT COUNT(DISTINCT main.id) FROM Tickets main , Links Links_1  WHERE ((main.EffectiveId = main.id)) AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( ( (Links_1.Type = 'RefersTo')AND(Links_1.LocalTarget = '2')AND(main.id = Links_1.LocalBase) ) )

And of course this one isn't right either if you have RTFM installed
and are looking for links to other tickets and not links to articles.

> 
> > 
> > > 
> > > -Todd
> > > _______________________________________________
> > > Rt-devel mailing list
> > > Rt-devel at lists.bestpractical.com
> > > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
> > > 
> > 
> > -- 
> _______________________________________________
> Rt-devel mailing list
> Rt-devel at lists.bestpractical.com
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel