Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 348699 - Data extraction task does not have access to all of a result sets data
Summary: Data extraction task does not have access to all of a result sets data
Status: RESOLVED WORKSFORME
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows 7
: P3 normal (vote)
Target Milestone: 3.7.0   Edit
Assignee: Birt-ReportEngine-inbox@eclipse.org CLA
QA Contact: Xiaoying Gu CLA
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-06-08 06:03 EDT by Jan Kohnert CLA
Modified: 2011-06-13 21:52 EDT (History)
3 users (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jan Kohnert CLA 2011-06-08 06:03:52 EDT
Build Identifier: v20100210-0630

There is discussion going on for this:
http://www.eclipse.org/forums/index.php/t/210372/

The original message was:
I've set up a data extraction task as described here:
http://wiki.eclipse.org/Data_Extract_%28BIRT%29_2.1

Using this, I can easily extract all data contained within the report. But, how can I extract the data that is contained in the result set delivered by the query defined in the reports design file but is not being shown anywhere in the report? I've checked the report document, and the unused data is contained inside this file. 

Is there a way to access this by API? 

I need this, because I want to register printed items. I do mark a item printed by its unique id. This registration is done after creating the document using the BIRT API. No report file scripting should be used. 
The id is contained in the result set, but is never being show somewhere. 

Example: My query delivers three columns:

NAME  VALUE  ID
----- ------ ----
foo   1      4711

'foo' and '1' is getting printed on the report.
4711 is the unique index to use to register the item. 

So for registration the unprinted column ID is required. 


Reproducible: Always

Steps to Reproduce:
1. Fill a data set with data.
2. Use some of the data within a report, for instance inside a table.
3. Create a data extraction task and try to access data of the data set that is not used in the report (bound to something). You'll not getting it.
4. Check the the created report document. The unused data is cotnained.
Comment 1 Wei Yan CLA 2011-06-08 14:12:54 EDT
You can add a data binding to the table. All the binding in the table will be exported event they are not used in the detail row.
Comment 2 Xiaoying Gu CLA 2011-06-13 02:26:16 EDT
Set as worksform based on comment #1.