search filter using searchkick

Question

I'm using searchkick in my rails app. When user types letters of the name he wants to find into form, I get it with params[:query]. The fields' names are (name, login, passwd). The result of searching returns in table. Something like this:

env1@something.com login1 passwd1
env1@something.com login2 passwd2
env2@something.com login1 passwd2
env2@something.com login2 passwd2
      ....

Searching works fine returning all matched names but the question is how can I get only those fields where the name matches query AND login = login1 for example?

Will appreciate your help. Thanks in advance.

score 1 · Answer 1 · answered Feb 12 '16 at 05:17

1

@users = User.search "*", where: {name: params[:query], login: params[:login]}

answered Feb 12 '16 at 05:17

Dias

862
8
17

score 0 · Answer 2 · edited Oct 14 '17 at 06:01

0

This query should help:

User.search(params[:query], where: {login: params[:login]})

edited Oct 14 '17 at 06:01

Aref Aslani

1,560
13
27

answered Mar 13 '15 at 21:57

Sharvy Ahmed

7,247
1
33
46

search filter using searchkick

2 Answers2