BIRT, How can I do a Query using SQL ( Property binding -Query Text)
Hi,
I'm using just Quality Manager, and I'm looking for custom reports, I'm using BIRT 2.6.2 with RTC plugin ( Version 4), and I would like to know more about some examples for SQL queries inside Data Set Properties:
So, I would like to create a custom query, where, I group each test case, and display all categories in one record for graph it.
Thank you.
I'm using just Quality Manager, and I'm looking for custom reports, I'm using BIRT 2.6.2 with RTC plugin ( Version 4), and I would like to know more about some examples for SQL queries inside Data Set Properties:
So, I would like to create a custom query, where, I group each test case, and display all categories in one record for graph it.
Thank you.
One answer
Hello,
you would need to access the DB directly using the JDBC data source for BIRT.
A good place to start researching would be:
http://wiki.eclipse.org/BIRT/FAQ/Data_Access#Supported_Data_Sources
Please note however, that your SQL query should not modify the DB in any way (no update, insert, delete, etc. queries, no DDL commands are allowed).
you would need to access the DB directly using the JDBC data source for BIRT.
A good place to start researching would be:
http://wiki.eclipse.org/BIRT/FAQ/Data_Access#Supported_Data_Sources
Please note however, that your SQL query should not modify the DB in any way (no update, insert, delete, etc. queries, no DDL commands are allowed).