Could someone from SQL Development team please reply to this thread?
Try debugging your report.
Copy it down to the user defined reports. Open the report, grab the query, and run it.
See anything amiss?
Thanks Jeff for your reply, I am not able to copy this report. Actually do not see that report in Reports Tree anywhere.
Let me provide you some more information, I am trying to do Unit Testing in SQL Developer and trying to look at Unit Test window under Reports>Unit Test Runs>Test Runs Code Coverage.
1 person found this helpful
Apologies, I forgot those reports aren't accessible out of the Unit Test UI.
Here's the query we run to get the unit test coverage, LINES COVERED
ul.unit_owner as "Unit_Owner",
ul.unit_name as "Unit_Name",
ul.suite_name as "Suite_Name",
count(*) as "Total_Lines",
count(all decode(ul.total_occur + ul.total_time, 0, null, 1)) as "Lines_Covered",
ul.run_date as "Run_Date",
ul.utsr_id as "Run_Id"
sr.name as suite_name,
sum(s.total_occur) as total_occur,
sum(s.total_time) as total_time
(:Unit_Owner is null or s.unit_owner like :Unit_Owner) and
(:Unit_Name is null or s.unit_name like :Unit_Name) and
sr.status = 'UT_SUCCESS' and
str.utsr_id = sr.utsr_id and
str.utr_id = tr.utr_id and
tr.utr_id = tir.utr_id and
tir.utir_id = s.utir_id
order by 1, 2, 3, 6 desc
Could you please provide me query for Test Runs Code Coverage? This query looks like its for Suite Runs Code Coverage.
Appreciate your help.
Never mind, I was able to tweak the query for Test Runs.
Thanks for your help.