Forum: Ferret ferret joins

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
Wesley E. (Guest)
on 2009-02-10 19:18
Hey everyone,

just a quick question about ferret and joins.

i have two models

class Option < ActiveRecord::Base
  require 'acts_as_ferret'
  acts_as_ferret :fields => [:sym, :description, :opra_root]


class Sym < ActiveRecord::Base
  require 'acts_as_ferret'
  acts_as_ferret :fields => [:sym, :description], :ferret =>
{:max_clauses => 5000}

the sym model has many options.

So i just want to know if i can use :joins when calling

query = "y*"
options =
      options[:select] = " options.opra_root, S.security_type, S.sym,
S.description as decs"
      options[:joins] = " as options INNER JOIN syms as S ON S.sym =

Option.find_with_ferret(query, {}, options)

Currently total_hits returns the correct value but length is always 0

Im very confused

This topic is locked and can not be replied to.