ModifyAll is a powerfull statement. However often it is required to modify multple fields within a filterset. Currently it would require multiple ModifyAll statements or looping through the recordset and modify each record 1 by 1. Both solutions have performance drawbacks. It would be nice to have the ability to modify multiple fields at once in a filtered recordset.

Of course when fields have to be validated this will never be a performing instruction so I don't think it is a requirement for ModifyAll to have a validation option.

MyRecord.SetRange(FilerField1, FilterValue1);
MyRecord.SetRange(FilerField2, FilterValue2);
MyRecord.ModifyAll(Field1, Value1, Field2, Value2, Field3, Value3);
Category: Development
Needs Votes
Ideas Administrator

Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team