It's all about the answers!

Ask a question

BIRT, How can I do a Query using SQL ( Property binding -Query Text)


0
1
Rafael Rodriguez Montes (23013126247) | asked Apr 16 '13, 1:05 p.m.
retagged May 20 '13, 3:10 a.m. by Krzysztof Kaźmierczyk (7.4k373103)
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.


One answer



permanent link
Piotr Aniola (3.7k11738) | answered Apr 17 '13, 9:24 a.m.
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).

Comments
Rafael Rodriguez Montes commented May 21 '13, 10:54 a.m.

Hi thank you for your response, 

My problem is .. I'm using deby database and I can't connect while jazz is running, so the only way I think is use the filters included in BIRT using jazz connector  

Your answer


Register or to post 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.