Using NoCodeBDD, you can easily assert values across multiple rows of a SQL result. For an example, let’s look at the following table, which is a result of a SQL query. If your requirement is to select all users with Age 32 and to assert the First Name and Last Name from both rows, then it can be easily done in NoCodeBDD by selecting Multiple Row option.
FirstName | LastName | Age | EmployeeID | UserId | |
Row 1 | Joe | Doe | 32 | EMP0001 | U0001 |
Row 2 | Joe | Blog | 32 | EMP0002 | U0002 |
Row 3 | Harry | Williams | 30 | EMP0003 | U0003 |
Row 4 | John | Kerry | 37 | EMP0003 | U0004 |
“How to test DB results without writing any code” blog post shows how a SQL can be added and a Single Row can be asserted. To Assert multiple row, simply select Multiple Row option and enter the row number in which the expected value is, enter the column name, condition and its value that you want to assert. That’s it.
Once you have provided all required information, NoCodeBDD will do all the hard work for you and automate the code in the background. All you have to do is, press the Run menu and run the scenario you just added. You can also view the results in the audit page. This is shown in the GIF below

As you can see, asserting a single row or a multiple rows using NoCodeBDD is extremely easy and all it takes is minutes compared to hours using a scripted automation solution.
Jerome Josephraj is the Founder and CTO of NoCodeBDD. He has more than 20 years of experience in Software Development and have been rolling out Behavior Driven Development for large projects in United Kingdom. He has a strong Java Development Background and have been working as a Technical Consultant. In one of his recent large enterprise projects, he has successfully rolled out Behavior Driven Development consisting of more than 1000 scenarios. He was also the Founder of http://www.campusinteraction.com, a student analytics portal, which was later bought by Preludesys. Based on his previous start-up experience and a strong Behavior Driven Development experience, he founded NoCodeBDD to accelerate BDD automation by 10x.