Databases
StackOverflow2013
Postsdbo
POHow do I set up a facet search with a many to many relationship using Sunspot?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow do I set up a facet search with a many to many relationship using Sunspot?
    text
    copied!<p>I haven't implemented a search feature before and feel a bit stuck. I have a Sunspot search feature which finds results based on keywords - this works great - but I now want to implement the multi select facet feature, but I can't even seem to figure out how to set-up a basic facet search.</p> <p>I have a many to many relationship (in rails not in real life):</p> <p>Class People has_many :skills, :through => experience (and vice versa etc)</p> <pre><code>Class People &lt; ActiveRecord::Base has_many :skills, :through =&gt; experience searchable do text :first_name, :surname end end </code></pre> <p>In the controller</p> <pre><code>@search = Sunspot.search(People) facet :skill_ids end </code></pre> <p>This is the basic example I can't get working. It generates this error:</p> <pre><code>Sunspot::UnrecognizedFieldError: No field configured for People with name 'skill_ids' </code></pre> <p><strong>How do I create the link to :skill_ids</strong></p> <p>I think I must be missing some reference in the model - but no examples I can find do reference the Ids of a relationship. Most of the examples I found use columns that are already in that model when using the facet functionality.</p> <ul> <li>How can I get the basic implementation working?</li> <li>How would I use this in the view - do I have to call hits.facet and iterate over the skills? What would the code look like to display this?</li> <li>How would I select multiple facets to search by?</li> <li>Should I put this in the community wiki?</li> </ul> <p>Thank you for your time!</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload