[Rt-devel] BUG: Search Builder link searching

Jesse Vincent jesse at bestpractical.com
Tue Dec 6 14:33:39 EST 2005




On Tue, Dec 06, 2005 at 03:10:24PM -0500, Todd Chapman wrote:
> On Tue, Dec 06, 2005 at 03:05:33PM -0500, Todd Chapman wrote:
> > 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.

Why? Only Tickets should be using LocalBase and LocalTarget.


More information about the Rt-devel mailing list