How to convert results of the sql database to final tables

1

Is there any document to help query all info in database and create final results like the .CSV file result?

I mean some pack of predefined queries like this:

SELECT * FROM Result WHERE ResultSeriesID IN
(SELECT ResultSeriesID FROM ResultSeries WHERE ResultTypeID ==
(SELECT ResultTypeID FROM ResultType WHERE Name == "myTable"))
2

@teder.ted we don’t since it is just standard SQL, so any tools you’d normally use will work.

The DB schema is published here:
https://doc.opentap.io/Developer%20Guide/Result%20Listener/#opentap-sql-database

Someone on here may be able to help you with more specifics, but I’m curious would just having both the SQL and CSV Result Listeners enabled at the same time meet your needs rather than trying to convert to CSV?

If you are using PathWave Test Automation you are also able to export to CSV from the Results Viewer.

3

I know this is an old post, but I have an SQL scrip to pull out test runs into a table listing all the steps executed and their results. It should work for any SQL tap database although there are some things specific to add-ons created for our particular scenario.

I attached the script here.

GetPlanRunInfo.sql.txt (6.4 KB)

1 Like