Hello Joshua,

Thank you for posting to Infragistics Community!

I have been looking into your question and I am wondering if you are leveraging the Grid Editing and Validation functionality to implement validation in this case? This is a relatively new feature introduced in our library since version 14.1.0. With it, the validation mechanism is triggered when editing both cells and rows. This leaves me under the impression that the validation on your side might be implemented by other, possibly custom approaches. Please, let me know if my assumptions are incorrect and do elaborate further in that case.

So, what I can suggest is checking out the built-in grid validation features. Additionally, unique validator is not among the supported out-of-the-box, however custom validators could also be set, as described in this section. As an example, please check out this StackBlitz demo, where a custom “unique values” validator is implemented and applied to the “ProductName” field.

In conclusion, please, check out the referenced resources and let me know if you need any further assistance on the matter.

Best regards,
Bozhidara Pachilova
Associate Software Developer

As documented in the Validation triggers section of the Grid Validation topic, validation is not triggered for cells/rows that are not edited via user input or via the editing API.

Having this in mind, the sequence that you are describing can still be achieved by implementing additional logic in this direction. I modified the previous sample to demonstrate a possible approach when row editing is allowed and by leveraging the grid’s updateRow method.

The initial invalid state could be “triggered” in the ngAfterViewInit hook:

  ngAfterViewInit(): void {
    this.data.forEach((entry) => {
      requestAnimationFrame(() => {
        this.grid.updateRow(entry, entry[this.grid.primaryKey]);
      });
    });
  }

And for the described row editing scenario in order to retrigger validation for the other invalid records that no longer should have errors after the particular row edit is finished, the rowEditDone event could be leveraged, for example:

 public rowEditDone(event) {
    let recValidationState: IRecordValidationState[] =
      this.grid.validation.getInvalid();
    recValidationState.forEach((rv) => {
      rv.fields.forEach((f) => {
        if (f.errors && f.errors.duplicateValue) {
          let rowData = this.grid.getRowData(rv.key);
          requestAnimationFrame(() => {
            this.grid.updateRow(rowData, rowData[this.grid.primaryKey]);
          });
        }
      });
    });
  }

Please, feel free to further modify this solution to fit your requirements. I hope it helps.

Best regards,
Bozhidara Pachilova
Associate Software Developer