[Rt-devel] BUG: Search Builder link searching
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