- check the modified query and report for checking if the expected data is now displaying in the report
- as per checking, the report still not showing some expected data
- modify the query again to display all the invalid data per department and test the query again, as per checking it is now displaying all the invalid data
- apply the query in the application and test the application again for checking the report
- as per checking, is it now displaying all the invalid and correct data
- test as well all the reports for checking and making sure that it is now affected
- as per checking, all the report is OK