From: "Mike C." <corki...@gmail.com>
Date: Wed, 7 Nov 2012 11:19:09 -0800 (PST)
Local: Wed, Nov 7 2012 2:19 pm
Subject: Re: Thinking Sphinx how to index the plusminus rank of Thumbs_up gem
Thumbs_up generates a votes model: class Vote < ActiveRecord::Base scope :for_voter, lambda { |*args| where(["voter_id = ? AND voter_type = belongs_to :voteable, :polymorphic => true attr_accessible :vote, :voter, :voteable # Comment out the line below to allow multiple votes per user. end and a vote migration containing: create_table "votes", :force => true do |t| I added this to my person model to filter by Most/Least amount of ratings: has_many :votes, as: :voteable define_index do has "COUNT(votes.id)", as: :rating, type: :integer end Although it isn't filtering the results by the number of votes that person The other issue is figuring out how to index the Highest and Lowest Rating. plusminus = (votes_for - votes_against) votes_for is total votes that are equal to 1 for voteable_id and Anyone able to make sense of this in sql for the attributes to index =) On Monday, November 5, 2012 10:56:18 PM UTC-5, Mike C. wrote:
> Anyone have experience with indexing vote ranks with the Thumbs_up gem?<https://github.com/bouchard/thumbs_up> > I'm trying to figure out these 4 attributes: > has Highest Rating (the plusminus tally in gem) DESC You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| ||||||||||||||