StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POUsing a rails scope query in a controller
primarykey
Id
18549845
data
AcceptedAnswerId
18550222
AnswerCount
1
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2013-08-31T15:45:17.900
FavoriteCount
1
LastActivityDate
2013-08-31T16:24:10.643
LastEditDate
2013-08-31T16:03:56.937
LastEditorUserId
2697793
OwnerUserId
2697793
ParentId
0
PostTypeId
1
Score
0
ViewCount
2606
LastEditorDisplayName
text
Body
I'm working on my first rails project, and I'm having trouble getting my query to work correctly. My overall goal is to setup a collection of scopes to create some long queries with multiple options. However, to start with, I'm just trying to set up a single scope, to query a single column from a single model. Here is my model: <pre><code> class Drawing < ActiveRecord::Base has_many :revisions scope :by_description, lambda { |description| where(description: description) unless description.nil? } end </code></pre> Here is the index action of my controller: <pre><code>def index @drawings = Drawing.by_description(params[:description]).all respond_to do |format| format.html # index.html.erb format.json { render json: @drawings } end end </code></pre> And the view is the default index view for rails. When I enter an input into the search field, for example "Case", the submit button works and directs me to the index view, but all of the "Drawings" are listed, instead of just the ones that have "Case" as their description. Thanks so much for your help. Here is the section of the development log file that applies, as you can see, the SQL being generated is not including the added description parameter: <pre><code>Started GET "/drawings?utf8=%E2%9C%93&drawings%5Bdescription%5D=Case&drawings%5Bdrawing_number%5D=&drawings%5Bitem_number%5D=&drawings%5Bpump_model%5D=&drawings%5Bframe_size%5D=&drawings%5Bpart_type%5D=&drawings%5Bcreated_before%281i%29%5D=&drawings%5Bcreated_before%282i%29%5D=&drawings%5Bcreated_before%283i%29%5D=&drawings%5Bcreated_after%281i%29%5D=&drawings%5Bcreated_after%282i%29%5D=&drawings%5Bcreated_after%283i%29%5D=&commit=Search" for 127.6.43.1 at 2013-08-31 11:39:28 -0400 Processing by DrawingsController#index as HTML Parameters: {"utf8"=>"✓", "drawings"=>{"description"=>"Case", "drawing_number"=>"", "item_number"=>"", "pump_model"=>"", "frame_size"=>"", "part_type"=>"", "created_before(1i)"=>"", "created_before(2i)"=>"", "created_before(3i)"=>"", "created_after(1i)"=>"", "created_after(2i)"=>"", "created_after(3i)"=>""}, "commit"=>"Search"} [1m[36mDrawing Load (0.3ms)[0m [1mSELECT "drawings".* FROM "drawings" [0m Rendered drawings/index.html.erb within layouts/application (6.0ms) Completed 200 OK in 226ms (Views: 186.8ms | ActiveRecord: 0.3ms) </code></pre>
Tags
<ruby-on-rails><ruby><ruby-on-rails-3><scope><rails-activerecord>
Title
Using a rails scope query in a controller
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USsabrams
UserOwnerUserId
1. USsabrams
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.