[Rt-devel] BUG: Search Builder link searching

[Jesse Vincent]

On Tue, Dec 06, 2005 at 03:22:21PM -0500, Todd Chapman wrote:
> > That looks like a bug.
> 
> I really don't understand the need for LocalTarget/LocalBase. Is
> it just an optimization? Target/Base should be all we need
> for searching...

Ok. Show me how to join the tickets table to the links table.

> 
> > > 
> > > mysql> select * from Links where LocalTarget='2';
> > > 
> > > | 11495 | fsck.com-rt://gedasusa.com/ticket/13653 | fsck.com-rtfm://gedasusa.com/article/2 | RefersTo |           2 |     13653 |           158 | 2005-04-07 19:05:16 |     158 | 2005-04-07 19:05:16 |
> > > | 11911 | fsck.com-rt://gedasusa.com/ticket/14068 | fsck.com-rtfm://gedasusa.com/article/2 | RefersTo |           2 |     14068 |           158 | 2005-04-14 15:11:40 |     158 | 2005-04-14 15:11:40 |
> > > | 16512 | fsck.com-rt://gedasusa.com/ticket/18587 | fsck.com-rtfm://gedasusa.com/article/2 | RefersTo |           2 |     18587 |           158 | 2005-06-23 14:34:16 |     158 | 2005-06-23 14:34:16 |
> > > | 16513 | fsck.com-rt://gedasusa.com/ticket/18787 | fsck.com-rtfm://gedasusa.com/article/2 | RefersTo |           2 |     18787 |           158 | 2005-06-23 14:34:38 |     158 | 2005-06-23 14:34:38 |
> > > | 16514 | fsck.com-rt://gedasusa.com/ticket/18924 | fsck.com-rtfm://gedasusa.com/article/2 | RefersTo |           2 |     18924 |           158 | 2005-06-23 14:41:12 |     158 | 2005-06-23 14:41:12 |
> > > 
> > 
> > -- 
> 

--