StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
4034966
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2010-10-27T15:34:51.020
FavoriteCount
0
LastActivityDate
2010-10-27T15:34:51.020
LastEditDate
LastEditorUserId
0
OwnerUserId
489040
ParentId
1482940
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
For Rails 2.x, you could use the following named scope to simulate OR: <pre><code> __or_fn = lambda do |*scopes| where = [] joins = [] includes = [] # for some reason, flatten is actually executing the scope scopes = scopes[0] if scopes.size == 1 scopes.each do |s| s = s.proxy_options begin where << merge_conditions(s[:conditions]) rescue NoMethodError where << scopes[0].first.class.merge_conditions(s[:conditions]) end joins << s[:joins] unless s[:joins].nil? includes << s[:include] unless s[:include].nil? end scoped = self scoped = scoped.includes(includes.uniq.flatten) unless includes.blank? scoped = scoped.joins(joins.uniq.flatten) unless joins.blank? scoped.where(where.join(" OR ")) end named_scope :or, __or_fn </code></pre> Let's use this function using your example above. <pre><code>q1 = Annotation.body_equals('?') q2 = Annotation.body_like('[?]') Annotation.or(q1,q2) </code></pre> The above code executes only one query. <code>q1</code> and <code>q2</code> do not hold the results of the query, rather, their class is <code>ActiveRecord::NamedScope::Scope</code>. The <code>or</code> named_scope combines these queries and joins the conditions with an OR. You could also nest ORs, like in this contrived example: <pre><code>rabbits = Animal.rabbits #<Animal id: 1 ...> puppies = Animal.puppies #<Animal id: 2 ...> snakes = Animal.snakes #<Animal id: 3 ...> lizards = Animal.lizards #<Animal id: 4 ...> Animal.or(rabbits, puppies) [#<Animal id: 1 ...>, #<Animal id: 2 ...>] Animal.or(rabbits, puppies, snakes) [#<Animal id: 1 ...>, #<Animal id: 2 ...>, #<Animal id: 3 ...>] </code></pre> Because <code>or</code> returns a <code>ActiveRecord::NamedScope::Scope</code> itself, we can go really crazy: <pre><code># now let's get crazy or1 = Animal.or(rabbits, puppies) or2 = Animal.or(snakes, lizards) Animal.or(or1, or2) [#<Animal id: 1 ...>, #<Animal id: 2 ...>, #<Animal id: 3 ...>, #<Animal id: 4...>] </code></pre> I believe that most of these examples would work fine using <code>scope</code>s in Rails 3, although I have not tried. A Bit of shameless self-promotion - This functionality is available in the <a href="http://github.com/gammons/fake_arel" rel="nofollow">fake_arel gem</a>.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POCombine two named scopes with OR (instead of AND)
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USGrant Ammons
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. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COThat was exactly what I needed, thank you!
 singulars
 PostPostId
 PO
 UserUserId
 USKARASZI István

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.