How to get specific data when pass multiple parameter at the end of url?

Question

I am using rails 4.2 of my application.

Below is index action of my Descriptions Controller.

def index
  @descriptions = Description.all
  if name = params[:name]
    description = @descriptions.where(name: name)
    render json: description
  end
end

and when I input http://localhost:3000/descriptions?name=LA to browser. I can get a data which name attributes is "LA" in JSON format. like below.

[{"id":140,"name":"LA","value":"Lakers","api_name_id":113,"created_at":"2015-06-04T17:11:18.649Z","updated_at":"2015-06-04T17:11:18.649Z"}]

However, if I pass two parameter at the end of my url like

http://localhost:3000/descriptions?name=LA&name=123

I can only get data which name attributes is "123" in JSON format.

[{"id":143,"name":"123","value":"456","api_name_id":114,"created_at":"2015-06-04T17:20:18.703Z","updated_at":"2015-06-04T17:20:18.703Z"}]

Is there any way that I can get all datas which name attributes is "LA" and also "123" ? Like below

[{"id":143,"name":"123","value":"456","api_name_id":114,"created_at":"2015-06-04T17:20:18.703Z","updated_at":"2015-06-04T17:20:18.703Z"},{"id":140,"name":"LA","value":"Lakers","api_name_id":113,"created_at":"2015-06-04T17:11:18.649Z","updated_at":"2015-06-04T17:11:18.649Z"}]

What is mean is all datas which name=LA or name=123. (this and is not &&) XD — Dreams, Jun 04 '15 at 19:41

score 1 · Accepted Answer · edited May 23 '17 at 12:29

1

Hit the url as :

http://localhost:3000/descriptions?name[]=LA&name[]=123

And rest your code is perfect. But remember where will do SQL IN operation. Look this answer to see how to pass array like elements with query string.

edited May 23 '17 at 12:29

Community

1
1

answered Jun 04 '15 at 19:11

Arup Rakshit

116,827
30
260
317

what if i pass two different attribute? one is "name" and another one is "value"..like http://localhost:3000/descriptions?name=LA&value=456 – Dreams Jun 04 '15 at 19:31
@LateBloomer That depends on how you want the query... AND or OR? – Arup Rakshit Jun 04 '15 at 19:32
if OR??How to implement? – Dreams Jun 04 '15 at 19:39
@LateBloomer `@descriptions.where("name = ? OR value = ?", params[:name], params[:value])` – Arup Rakshit Jun 04 '15 at 19:42
I really apreciate.Is there any way that can pass two same attribute?like localhost:3000/descriptions?name=LA&name=NY&value=456&value=789 – Dreams Jun 04 '15 at 19:54
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/79693/discussion-between-r-o-r-and-latebloomer). – Arup Rakshit Jun 04 '15 at 19:58

score 0 · Answer 2 · answered Jun 04 '15 at 19:16

0

maybe you'll want

unless params.empty?
 description = {}
 params.each do |key, value|
  description.merge(@descriptions.where(name: value)) if key == name
 end
end

answered Jun 04 '15 at 19:16

rkamun1

338
1
2
15

How to get specific data when pass multiple parameter at the end of url?

2 Answers2