Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 360205 - Uable to fetch nested column of mongo DB
Summary: Uable to fetch nested column of mongo DB
Status: RESOLVED WONTFIX
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: ---   Edit
Assignee: Birt-DataAccess CLA
QA Contact: Maggie Shen CLA
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-10-07 04:46 EDT by Harmeet CLA
Modified: 2013-08-15 23:55 EDT (History)
2 users (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.