Forum Discussion

e2x_Limited_Sup's avatar
e2x_Limited_Sup
New Contributor
12 years ago

Datadriven Testing - Overall Result by Row - How to?

Hi there

I am relatively new to datadriving in SoapUI pro - I am looking to implement a report where I can get the overall result for each data row so that I can drill down and investigate issues, as well as report Pass/fail/not runs to my team - What is the simplest way of doing this?

I am currently datadriving from an Oracle DB, testing REST services.

Using SoapUI Pro 4.6.0

Thanks

TB

3 Replies

  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    12 years ago
    Hi,

    Just to clarify, do you want to

    1) Implement a report that shows the result of the database query for every data row, or
    2) Implement a report that shows the result of the entire loop for every data row?

    Regards,
    Arian
    SmartBear Sweden
  • URN123's avatar
    URN123
    Occasional Contributor
    12 years ago
    Hi,

    If I understood you correctly, you will be reading data from Oracle, execute a test and you want to save the result of this execution. If this is the case, here is what you can do:

    If you know, what you are expecting out of a test(every row) then create some validations either using the ASSERTIONS feature present in Soap-UI Pro or by writing some groovy script. Create one more groovy script that checks if all your validations have passed or not. Then write the overall result for this row/test to an excel file with as much detail as you need (overall pass/fail, individual assertion results, response etc.)

    I am expecting you already have a data source loop. Put the above steps inside your loop. So by the time your loop is completed, you will have all the results in an excel sheet the way you want.

    Hope the above explanation helps you.