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

Rafael Rodriguez Montes (230●13●114●224) | asked Apr 16 '13, 1:05 p.m.
retagged May 20 '13, 3:10 a.m. by Krzysztof Kaźmierczyk (7.4k●3●63●102)

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

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Piotr Aniola (3.7k●1●16●38) | 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

It's all about the answers!

Related questions

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

One answer

Your answer