I 'd like to have a unique field, but the uniqueness depends on the docstatus, for example if my field name is
sort_id and a submitted record exists where
sort_id = 455 and that document is cancelled, no error should show, but creation of new records with the same
sort_id should be prohibited.
How can I do this.