Specific Solutions to Specific Problems

Check for Duplicate Transaction IDs

Transaction.where(:year => 2022).select("COUNT(gwtranid) as total, gwtranid").group(:gwtranid).having("COUNT(gwtranid) > 1").order(:gwtranid).map{|p| {p.gwtranid => p.total} }