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"))
@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.