Need a sample SQL query for the "ALL Defects" report.
We are in need of creating a custom SQL query to get an All Defects Customizable Defect Report. The Collaborator v12.2 states that there is an SQL button that would generate an SQL query which can then be customized.
Since v9.3 does not support this feature, I wonder if you can supply a sample SQL query for the All Defects report that we can use as a starting point ( a query generated with 12.2 may be sufficient).
We will also need an SQL query to get a dect detail report ( if available).