Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 360205

Summary: Uable to fetch nested column of mongo DB
Product: z_Archived Reporter: Harmeet <harmeet.singh>
Component: BIRTAssignee: Birt-DataAccess <Birt-DataAccess-inbox>
Status: RESOLVED WONTFIX QA Contact: Maggie Shen <lshen>
Severity: normal    
Priority: P3 CC: bluesoldier, lchan
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows 7   
Whiteboard:

Description Harmeet CLA 2011-10-07 04:46:29 EDT 
Build Identifier: 3.7.0

I am not able to pick nested column from database. say column basicinfo has sub columns as firstname,lastname,DateOfBirth.

To fetch firstname from mongo db we use syntax (basicinfo.firstname).

but this syntax is not working in birt.
I have entered following syntax in query textbox for dataset


Syntax: tablename(userid,username,basicinfo.firstname)

this is not working in birt

Reproducible: Always
Comment 1 Xiaoying Gu CLA 2011-11-01 02:44:53 EDT 
will not support according to DTE
Comment 2 Linda Chan CLA 2013-08-15 23:55:16 EDT 
BIRT 4.3 (Kepler) now offers a MongoDB ODA connector, see Bug 402794.