CODEWITHSUNDEEP
ruby-on-railsruby-on-rails-4
Prabhakar
Prabhakar

Reputation: 6764

rails 4 syntax changes

How can I rewrite this below code with rails 4 new syntax.

Tracker.find(:all, :joins => :projects,
                         :select => "DISTINCT #{Tracker.table_name}.*",
                         :conditions => ["#{Project.table_name}.lft >= ? AND #{Project.table_name}.rgt <= ? AND #{Project.table_name}.status <> #{STATUS_ARCHIVED}", lft, rgt],
                         :order => "#{Tracker.table_name}.position")

Upvotes: 0

Views: 73

Answers (1)

Arup Rakshit
Arup Rakshit

Reputation: 118271

Below is the equivalent way :

Tracker.joins(:projects)
       .where("#{Project.table_name}.lft >= ? AND #{Project.table_name}.rgt <= ? AND #{Project.table_name}.status <> #{STATUS_ARCHIVED}", lft, rgt)
       .select("DISTINCT #{Tracker.table_name}.*")
       .order("#{Tracker.table_name}.position")

Upvotes: 1

Related Questions