Criteria Based Validation
You can display error line numbers by including the following in the error message template:
LineNumber - Error Line Number - Criteria Based Validation Error Lines
The error happened at Line Number {$map.errorLines}
Check old data:
Example:
select case when {remarks}<>{oldData.remarks} then 1 else 0 end
Don't ignore spaces: Example:
select case when {remarks}<>{oldData.remarks} and coalesce({oldData.remarks},'')<>'' then 1 else 0 end