Method: Naf::Affinity.deleted_machine_affinities

Defined in:
app/models/naf/affinity.rb

.deleted_machine_affinities ⇒ Object 



54
55
56
57
58
59
60
 
# File 'app/models/naf/affinity.rb', line 54

def self.deleted_machine_affinities
  joins(:affinity_classification).
  joins("INNER JOIN #{Naf.schema_name}.machines AS m
    ON CAST (m.id AS TEXT) = #{Naf.schema_name}.affinities.affinity_name").
  where("#{Naf.schema_name}.affinity_classifications.affinity_classification_name = 'machine' AND
    m.deleted IS TRUE")
end