I've written a couple of complex queries (at least to me) with Ruby on Rail's query interface: watched_news_posts = Post.joins(:news => :watched).where(:watched => {:user_id => id}) watch...

Example class User has_many :tickets end I want to create association which contains logic of count tickets of user and use it in includes (user has_one ticket_count) Users.includes(:tickets...

I would like to perform an ActiveRecord query that returns all records except those records that have certain ids. The ids I would like excluded are stored in an array. So: ids_to_exclude = [1,2,3...

If I have an association name as a string, is there a way I can get a handle on the association object? For example: o = Order.first o.customer will give me the customer object that this order ...

Suppose I have the following models: class Post < ActiveRecord::Base has_many :authors class Author < ActiveRecord::Base belongs_to :post And suppose the Author model has an attribute, ...

First, I am getting the review statuses between particular dates. date_range = Date.parse(@from_date).beginning_of_day..Date.parse(@to_date).end_of_day @review_statuses = ReviewStatus.where(updat...

I have searched but not able to find the brief explanation for the difference between ActiveRecord and ActiveRecord::relation object. I have understand that ActiveRecord is the single object find ...

I need to be able to chain an arbitrary number of sub-selects with UNION using ActiveRelation. I'm a little confused by the ARel implementation of this, since it seems to assume UNION is a binary ...

Using Arel in Rails - I'm looking for a way of creating an ActiveRecord::Relation that effectively results in SELECT * FROM table, which I can still manipulate further. For example, I have a model...

To get all posts with publisher_id equals to 10, 16, or 17, I do: Post.where(:publisher_id => [10, 16, 17]) How would I get all posts with publisher_id not equals to 10, 16, or 17 (i.e. all p...

This is related to a question a year and change ago. I put up an example of the question that should work out of the box, provided you have sqlite3 available: https://github.com/cairo140/rails-eag...

How can I turn the following SQL query into an ActiveRecord relation so that I can expand on it with scopes? WITH joined_table AS ( SELECT workout_sets.weight AS weight, workouts.user_id AS use...

I have code like this: t = "%#{term}%" where('name like ? or email like ? or postcode like ?', t, t, t) As you can see it's performing a search across several fields. Is there a way to avoid th...

I'm trying to create an app in Rails 3.1 with mysql2 v 0.2.6. When running rake db:create, I get the following error: DEPRECATION WARNING: Arel::Visitors::VISITORS is deprecated and will be remove...

I have a Transaction class. Each object of this class includes one issuing account, one sending account and one receiving account. Each of these is an instance of Account class. In my Transaction t...

I've looked over the Arel sources, and some of the activerecord sources for Rails 3.0, but I can't seem to glean a good answer for myself as to whether Arel will be changing our ability to use incl...

I am having this unexplained ActiveRecord::Relation, undefined method error . I don't know why, since my model association are well defined and the event table has the foreign keys for the user tab...