Validation of three fields question

[ricklach]

In a table I want to validate as unique three fields person_id, app_type and issue_id so that no duplicates appear in the table. Is there a special syntax for this type of validation?

Rick

[vgarcia]

class App << ActiveRecord::Base
  validates_uniqueness_of :person_id, :app_type, :issue_id
end

[ricklach]

I think what I was looking for was more along the lines of

validates_uniqueness_of :person_id && :app_type && :issue_id

. Unless the syntax is wrong, this fills the bill.

Rick

[DougBTX]

The easiest way would be to add a composite "UNIQUE" index to the database, I'm not sure how to do it with the built in validators.

Douglas

[ricklach]

Good point Douglas. Sometimes we forget the obvious.

Rick