Queries: complex SQL-like queries
We are looking at moving things into RTC 3.0, and we have a large number of automated "reports" that use SQL-like queries (very complex, multiple tables/view with inner and outer joins, etc), as well as reports which aggregate the outcome of 3 or 4 of these complex queries.
I've been going through some tutorials, but creating a query using the RTC UI seems difficult when the queries are very complex. Does RTC provide a way to do a query where we can "play" with the lower-level SQL? Susan |
One answer
Does RTC provide a way to do a query where we can "play" with the lower-level SQL?Susan The query builder for work items doesn't give you that level of SQL-like query building, but you can get it in the BIRT report builder. It uses a data warehouse schema which is available for full SQL query. Scott Rich IBM Rational |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.