Agfdhyk

I have a model Property, and I have a virtual attribute that is defined like this:

  def uid_type

    if mls? && mls.to_i != 0

      "MLS"

    elsif property_identifier? && property_identifier.to_i != 0

      "PID"

    else

      "ID"

    end

  end

Such that if I have a property p, when I query that virtual attribute, this is what I see:

> p.uid_type

 => "MLS" 

Basically, what I want to do is create a scope on my model to return all properties that have uid_type == 'MLS'.

How do I do that?

Edit 1

If I try this:

Property.where('properties.uid_type == "MLS"').count

   (4.6ms)  SELECT COUNT(*) FROM "properties" WHERE (properties.uid_type == "MLS")

ActiveRecord::StatementInvalid: PG::UndefinedColumn: ERROR:  column properties.uid_type does not exist

LINE 1: SELECT COUNT(*) FROM "properties"  WHERE (properties.uid_typ...

You have to write your own scope, ActiveRecord doesn't help much with custom methods.

scope :with_mls_uid_type, -> { where.not(mls: [nil, '']) }

Which will translate to:

SELECT "properties".* 

FROM "properties" 

WHERE ("properties"."mls" IS NOT NULL) 

AND ("properties"."mls" != '')

If your tag is correct and you're still on Rails 3.2 then you won't have .not and you will have to do:

where("mls IS NOT NULL AND mls != ''")