1)the data such as sample message is being passed using the xml
2) now the message falls in sql storage
3) now at log portal we fetch the data in gridview
4) we have expected data in excel sheet according to filter such as category.
5) unit test cases example on how to do it . actually wanted help in protractor c#
for grid anugular js i.e ng grid used .
6) create the automated unit cases regarding fetching data from grid and compare at excel
in excel , we have the test data prepared.