Just to confirm - the percentile values are integers, right?
--
Pat
On 02/01/2012, at 11:48 PM, mohitnegi wrote:
> define_index do
> indexes sex, :sortable => true
> indexes name_as_tenth, :sortable => true
> indexes category, :as => :category, :sortable => true
> indexes disability, :as => :disability, :sortable => true
> indexes certifications(:certificate), :as => :certifications
> indexes skill_records(:skill), :as => :skill
>
> indexes sslc_record(:year_of_completion), :as =>
> :sslc_year_of_completion, :sortable => true
> indexes puc_record(:year_of_completion), :as => :puc_year_of_completion,
> :sortable => true
> indexes user.tests_users(:reg_no), :as =>:reg_no
>
> has :id, d_o_b
> has user_id, :as=>:profile_user_id
> has sslc_record(:id), :as => :sslc_record_id
> has sslc_record.score, :as => :sslc_score, :type=>:float
> has puc_record(:id), :as => :puc_record_id
> has puc_record.score, :as => :puc_score, :type=>:float
>
> has diploma_record(:university_id), :as => :diploma_university_id,
> :type=>:integer
> has diploma_record(:specialization_id), :as =>
> :diploma_specialization_id, :type=>:integer
> has diploma_record(:score), :as => :diploma_score, :type=>:float
>
> has graduation_record(:university_id), :as => :graduation_university_id,
> :type=>:integer
> has graduation_record(:degree_id), :as => :graduation_degree_id,
> :type=>:integer
> has graduation_record(:specialization_id), :as =>
> :graduation_specialization_id, :type=>:integer
> has graduation_record(:score), :as => :graduation_score, :type=>:float
> has "substring(graduation_records.start_date,4,4)", :as =>
> :graduation_start_date, :type=>:integer
> has "substring(graduation_records.end_date,4,4)", :as =>
> :graduation_end_date, :type=>:integer
>
> has post_graduation_record(:university_id),
> :as=>:post_graduation_university_id
> has post_graduation_record(:degree_id), :as => :post_graduation_degree_id
> has post_graduation_record(:specialization_id), :as =>
> :post_graduation_specialization_id
> has post_graduation_record(:score), :as => :post_graduation_score,
> :type=>:float
> has "substring(post_graduation_records.start_date,4,4)", :as =>
> :post_graduation_start_date, :type=>:integer
> has "substring(post_graduation_records.end_date,4,4)", :as =>
> :post_graduation_end_date, :type=>:integer
>
>
> has user.tests_users.score(:overall_percentile), :as =>
> :overall_percentile
>
> has user.tests_users.score(:subsection1_percentile), :as =>
> :subsection1_percentile
> has user.tests_users.score(:subsection2_percentile), :as =>
> :subsection2_percentile
> has user.tests_users.score(:subsection3_percentile), :as =>
> :subsection3_percentile
>
> has user.tests_users.score(:test_id), :as => :test_ids
> end
>
> search query can be like
>
> Profile.search_for_ids
> :with=>{:overall_percentile=>(94..100),:subsection1_percentile=>(99..100),:subsection2_percentile=>(90..99)}
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Thinking Sphinx" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/thinking-sphinx/-/Qa_j2LlhR0UJ.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/thinking-sphinx?hl=en.
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en.
