This assertion counts rows of a result-set and compares it to an expectation. The possible comparisons are equal, equal, more-than and less-than.
System under test
The system-under-test is a query, please reports to other tests for more information about how to define a query. More info here.
The assertion consists in an xml element named row-count.
In this element, you must also specify an the comparison that you want to apply equal, more-than and less-than. You must also specify the reference to compare.
For the comparisons more-than and less-than, you can slightly change the behavior by adding the attribute or-equal and setting its value to true.
It’s possible to dynamically define the value that is used in the comparison. To achieve this you must use a global variable as explained there.
Note that if this variable is a percentage it must be returned as a string (double quotes)!
Row-count of another result-set
It’s possible to compare the row-count of the first result-set defined in the system-under-test to the row-count of a second result-set defined in the assertion to achieve this, use the projection row-count and define your second result-set with the syntax 2.0.