CODEWITHSUNDEEP
ruby-on-rails
johnc
johnc

Reputation: 741

How do I validate two fields for uniqueness

I need to validate the uniqueness of two fields in an object (row) before I add them. Employee_id and area_id are the two fields in my emp_area table. There can be multiple records with the same employee_id and multiple records with the same area_id, but no two records can have the same employee_id and the same area_id. This is sort of like two fields making up a primary-key or unique-key.

How can I do this.

Thanks

Upvotes: 73

Views: 23194

Answers (2)

Naveed
Naveed

Reputation: 11167

what about this solution Validate combined values

validates :employee_id, uniqueness: { scope: :area_id }

Upvotes: 99

JRL
JRL

Reputation: 77995

validates_uniqueness_of :employee_id, :scope => :area_id

Upvotes: 69

Related Questions