Welcome to WuJiGu Developer Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
346 views
in Technique[技术] by (71.8m points)

ruby on rails - Query to show n records per category with searckick gem - elasticsearch

I'm using searchkick gem and will_paginate gem.

i would like to make my search result page display n products for each category. For example when user search for "cat" it would display some thing like this..

    item    category 
    cat 1    image
    cat 2    image
    cat n    image
            
    item   category
    cat 1     video
    cat 2     video
    cat n     video
    
    ... etc

  page 1  2  3 (pagination)

right now my query is not efficient since i make each query for each category

@category1 = Listing.search(query,
                                  where: { category: 1},
                                  page: params[:page],
                                  per_page: 30)


@category2 = Listing.search(query,
                                  where: { category: 2},
                                  page: params[:page],
                                  per_page: 30)

what is the better approach ? thank u


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
等待大神答复

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to WuJiGu Developer Q&A Community for programmer and developer-Open, Learning and Share
...