[Rt-devel] BUG: Search Builder link searching
jesse at bestpractical.com
Tue Dec 6 15:20:40 EST 2005
On Tue, Dec 06, 2005 at 03:53:54PM -0500, Todd Chapman wrote:
> On Tue, Dec 06, 2005 at 02:58:58PM -0500, Jesse Vincent wrote:
> > 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.
> I think I see the problem. Does that mean you can't join
> rtfm articles to the links table?
Nope. it means we need to store the Article's URI in the Articles table
(which is what we do). It was something I wasn't comfortable doing with
the "primary" object in RT, but for future changes, benchmarking can
sway me. (But joining on ints will alaways be faster than joining on a
More information about the Rt-devel