Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » mongodb-oda-birt-plugin - JSONPath
mongodb-oda-birt-plugin - JSONPath [message #1112860] Fri, 20 September 2013 05:17 Go to next message
Eclipse UserFriend
Hallo,
we need to use Your plugin "mongodb-oda-birt-plugin" for eclipse. But there we need special filtering of data displayed in BIRT report.
More precisely: in mongoDB we have stored documents of tree form - root document contains maps of other documents and those contained
documents contains next document maps - overall three levels. Documents are objects of related classes but not the same classes.
We need to create BIRT report in eclipse from our mongoDB in tree form. The tree report form would be resolvable but we can't select from mongoDB
nested documents in doc tree via through the use of mongodb-oda-birt-plugin.
I would like to ask You if there is possibility to use JSONPath in definition of "Computed Collumns" in Data Set definition.



Here is the our sample BSON database:
/* 0 */
{
"_id" : ObjectId("5214bb59132bf5b98613c970"),
"className" : "com.fja.ipl.tools.setak.testreport.Bundle",
"failedTests" : {
"AcceptanceTestToolGuiTestSuite->Suite_NaturalPersonsSuite->Suite_CheckNaturalPersons\t\t\t\t->TEST CASE: 'Test_CheckNaturalPersons'" : "expected:<1> but was:<0>",
"AcceptanceTestToolGuiTestSuite\t\t->TEST CASE: 'Test_SearchBusinessPartner'" : "expected:<Bistum Maribor[_]lMdGYF (58076)> but was:<Bistum Maribor[]lMdGYF (58076)>",
"AcceptanceTestToolGuiTestSuite->Suite_NaturalPersonsSuite\t\t\t->TEST CASE: 'Test_EnterNaturalPerson'#1" : "Cannot locate element with text: Hausanschrift\nFor documentation on this error, please visit: \nBuild info: version: 'unknown', revision: 'unknown', time: 'unknown'\nSystem info: os.name: 'Windows 7', os.arch: 'x86', os.version: '6.1', java.version: '1.6.0_35'\nDriver info: driver.version: unknown",
"AcceptanceTestToolGuiTestSuite\t\t->TEST CASE: 'Test_FailureBusinessPartner'" : "expected:<Bistum Maribor[_]lMdGYF (58076)> but was:<Bistum Maribor[]lMdGYF (58076)>",
"AcceptanceTestToolGuiTestSuite->Suite_NaturalPersonsSuite\t\t\t->TEST CASE: 'Test_EnterNaturalPerson'#2" : "Cannot locate element with text: Hausanschrift\nFor documentation on this error, please visit: \nBuild info: version: 'unknown', revision: 'unknown', time: 'unknown'\nSystem info: os.name: 'Windows 7', os.arch: 'x86', os.version: '6.1', java.version: '1.6.0_35'\nDriver info: driver.version: unknown",
"AcceptanceTestToolGuiTestSuite->Suite_NaturalPersonsSuite->Suite_CheckNaturalPersons\t\t\t\t->TEST CASE: 'Test_Login_Superuser'" : "Unable to locate element: {\"method\":\"id\",\"selector\":\"loginUserName\"}\nBuild info: version: 'unknown', revision: 'unknown', time: 'unknown'\nSystem info: os.name: 'Windows 7', os.arch: 'x86', os.version: '6.1', java.version: '1.6.0_35'\nDriver info: driver.version: unknown"
},
"name" : "Hlavny bundle 2",
"containsChild" : true,
"childPredicates" : {
"AcceptanceTestToolGuiTestSuite" : {
"className" : "com.fja.ipl.tools.setak.testreport.Suite",
"allTests" : 18,
"failedTests" : 6,
"successfulTests" : 12,
"runTime" : "3 min, 57 s",
"name" : "AcceptanceTestToolGuiTestSuite",
"containsChild" : false,
"childPredicates" : {
"Suite_TestSuite1" : {
"className" : "com.fja.ipl.tools.setak.testreport.Suite",
"allTests" : 6,
"failedTests" : 0,
"successfulTests" : 6,
"runTime" : "1 min, 14 s",
"name" : "AcceptanceTestToolGuiTestSuite->Suite_TestSuite1",
"containsChild" : false,
"childPredicates" : {
"Suite_TestSuite1_2" : {
"className" : "com.fja.ipl.tools.setak.testreport.Suite",
"allTests" : 3,
"failedTests" : 0,
"successfulTests" : 3,
"runTime" : "0 min, 33 s",
"name" : "AcceptanceTestToolGuiTestSuite->Suite_TestSuite1->Suite_TestSuite1_2",
"containsChild" : false,
"childPredicates" : {
"Suite_TestSuite1_2_1" : {
"className" : "com.fja.ipl.tools.setak.testreport.Suite",
"allTests" : 3,
"failedTests" : 0,
"successfulTests" : 3,
"runTime" : "0 min, 32 s",
"name" : "AcceptanceTestToolGuiTestSuite->Suite_TestSuite1->Suite_TestSuite1_2->Suite_TestSuite1_2_1",
"containsChild" : false,
"childPredicates" : {
"TEST CASE: 'Test_EnterBusinessPartner'#3" : {
"className" : "com.fja.ipl.tools.setak.testreport.Test",
"date" : "Wed Aug 21 15:06:04 CEST 2013",
"name" : "\t\t\t\t\t->TEST CASE: 'Test_EnterBusinessPartner'#3",
"result" : "Passed",
"containsChild" : false
},
"PREDICATE: 'cidLoginUser'#4" : {
"className" : "com.fja.ipl.tools.setak.testreport.Test",
"date" : "Wed Aug 21 15:06:00 CEST 2013",
"name" : "\t\t\t\t\t->PREDICATE: 'cidLoginUser'#4",
"result" : "Passed",
"containsChild" : false
},
"TEST CASE: 'Test_PassingParameters'#2" : {
"className" : "com.fja.ipl.tools.setak.testreport.Test",
"date" : "Wed Aug 21 15:06:26 CEST 2013",
"name" : "\t\t\t\t\t->TEST CASE: 'Test_PassingParameters'#2",
"result" : "Passed",
"containsChild" : false
}
}
}
}
},
"Suite_TestSuite1_1" : {
"className" : "com.fja.ipl.tools.setak.testreport.Suite",
"allTests" : 3,
"failedTests" : 0,
"successfulTests" : 3,
"runTime" : "0 min, 27 s",
"name" : "AcceptanceTestToolGuiTestSuite->Suite_TestSuite1->Suite_TestSuite1_1",
"containsChild" : false,
"childPredicates" : {
"TEST CASE: 'Test_EnterBusinessPartner'#2" : {
"className" : "com.fja.ipl.tools.setak.testreport.Test",
"date" : "Wed Aug 21 15:05:23 CEST 2013",
"name" : "\t\t\t\t->TEST CASE: 'Test_EnterBusinessPartner'#2",
"result" : "Passed",
"containsChild" : false
},
"TEST CASE: 'Test_PassingParameters'#1" : {
"className" : "com.fja.ipl.tools.setak.testreport.Test",
"date" : "Wed Aug 21 15:05:40 CEST 2013",
"name" : "\t\t\t\t->TEST CASE: 'Test_PassingParameters'#1",
"result" : "Passed",
"containsChild" : false
},
"PREDICATE: 'cidLoginUser'#3" : {
"className" : "com.fja.ipl.tools.setak.testreport.Test",
"date" : "Wed Aug 21 15:05:19 CEST 2013",
"name" : "\t\t\t\t->PREDICATE: 'cidLoginUser'#3",
"result" : "Passed",
"containsChild" : false
}
}
}
}
},
"TEST CASE: 'Test_EnterBusinessPartner'#1" : {
"className" : "com.fja.ipl.tools.setak.testreport.Test",
"date" : "Wed Aug 21 15:02:45 CEST 2013",
"name" : "\t\t->TEST CASE: 'Test_EnterBusinessPartner'#1",
"result" : "Passed",
"containsChild" : false
},
"Suite_NaturalPersonsSuite" : {
"className" : "com.fja.ipl.tools.setak.testreport.Suite",
"allTests" : 5,
"failedTests" : 4,
"successfulTests" : 1,
"runTime" : "1 min, 24 s",
"name" : "AcceptanceTestToolGuiTestSuite->Suite_NaturalPersonsSuite",
"containsChild" : false,
"childPredicates" : {
"Suite_CheckNaturalPersons" : {
"className" : "com.fja.ipl.tools.setak.testreport.Suite",
"allTests" : 2,
"failedTests" : 2,
"successfulTests" : 0,
"runTime" : "0 min, 24 s",
"name" : "AcceptanceTestToolGuiTestSuite->Suite_NaturalPersonsSuite->Suite_CheckNaturalPersons",
"containsChild" : false,
"childPredicates" : {
"TEST CASE: 'Test_Login_Superuser'" : {
"className" : "com.fja.ipl.tools.setak.testreport.Test",
"date" : "Wed Aug 21 15:04:40 CEST 2013",
"name" : "\t\t\t\t->TEST CASE: 'Test_Login_Superuser'",
"result" : "Failed",
"containsChild" : false
},
"TEST CASE: 'Test_CheckNaturalPersons'" : {
"className" : "com.fja.ipl.tools.setak.testreport.Test",
"date" : "Wed Aug 21 15:04:58 CEST 2013",
"name" : "\t\t\t\t->TEST CASE: 'Test_CheckNaturalPersons'",
"result" : "Failed",
"containsChild" : false
}
}
},
"TEST CASE: 'Test_EnterNaturalPerson'#2" : {
"className" : "com.fja.ipl.tools.setak.testreport.Test",
"date" : "Wed Aug 21 15:04:12 CEST 2013",
"name" : "\t\t\t->TEST CASE: 'Test_EnterNaturalPerson'#2",
"result" : "Failed",
"containsChild" : false
},
"TEST CASE: 'Test_EnterNaturalPerson'#1" : {
"className" : "com.fja.ipl.tools.setak.testreport.Test",
"date" : "Wed Aug 21 15:03:45 CEST 2013",
"name" : "\t\t\t->TEST CASE: 'Test_EnterNaturalPerson'#1",
"result" : "Failed",
"containsChild" : false
},
"PREDICATE: 'cidLoginUser'#2" : {
"className" : "com.fja.ipl.tools.setak.testreport.Test",
"date" : "Wed Aug 21 15:03:40 CEST 2013",
"name" : "\t\t\t->PREDICATE: 'cidLoginUser'#2",
"result" : "Passed",
"containsChild" : false
}
}
},
"TEST CASE: 'Test_MultipleAssertTabAndPage'" : {
"className" : "com.fja.ipl.tools.setak.testreport.Test",
"date" : "Wed Aug 21 15:03:36 CEST 2013",
"name" : "\t\t->TEST CASE: 'Test_MultipleAssertTabAndPage'",
"result" : "Passed",
"containsChild" : false
},
"TEST CASE: 'Test_SearchBusinessPartner'" : {
"className" : "com.fja.ipl.tools.setak.testreport.Test",
"date" : "Wed Aug 21 15:03:01 CEST 2013",
"name" : "\t\t->TEST CASE: 'Test_SearchBusinessPartner'",
"result" : "Failed",
"containsChild" : false
},
"TEST CASE: 'Test_FailureBusinessPartner'" : {
"className" : "com.fja.ipl.tools.setak.testreport.Test",
"date" : "Wed Aug 21 15:03:12 CEST 2013",
"name" : "\t\t->TEST CASE: 'Test_FailureBusinessPartner'",
"result" : "Failed",
"containsChild" : false
},
"PREDICATE: 'cidLoginUser'#1" : {
"className" : "com.fja.ipl.tools.setak.testreport.Test",
"date" : "Wed Aug 21 15:02:36 CEST 2013",
"name" : "\t\t->PREDICATE: 'cidLoginUser'#1",
"result" : "Passed",
"containsChild" : false
},
"TEST CASE: 'Test_CloseMultipleTabs'" : {
"className" : "com.fja.ipl.tools.setak.testreport.Test",
"date" : "Wed Aug 21 15:03:25 CEST 2013",
"name" : "\t\t->TEST CASE: 'Test_CloseMultipleTabs'",
"result" : "Passed",
"containsChild" : false
},
"TEST CASE: 'Test_CloseSingleTab'" : {
"className" : "com.fja.ipl.tools.setak.testreport.Test",
"date" : "Wed Aug 21 15:02:40 CEST 2013",
"name" : "\t\t->TEST CASE: 'Test_CloseSingleTab'",
"result" : "Passed",
"containsChild" : false
}
}
}
}
}

/* 1 */
{
"_id" : ObjectId("5217385e4bcaa8955cb36d49"),
"className" : "com.fja.ipl.tools.setak.testreport.Bundle",
"failedTests" : ["AcceptanceTestsSuite\t\t->TEST CASE: 'Test_CheckFoundBusinessPartner'"],
"childPredicates" : [{
"className" : "com.fja.ipl.tools.setak.testreport.Suite",
"allTests" : 3,
"failedTests" : 1,
"successfulTests" : 2,
"runTime" : "1 min, 2 s",
"name" : "AcceptanceTestsSuite",
"childPredicates" : [{
"className" : "com.fja.ipl.tools.setak.testreport.Test",
"date" : "Fri Aug 23 12:23:25 CEST 2013",
"name" : "\t\t->TEST CASE: 'Test_SearchBusinessPartner'",
"result" : "Passed"
}, {
"className" : "com.fja.ipl.tools.setak.testreport.Test",
"date" : "Fri Aug 23 12:23:41 CEST 2013",
"name" : "\t\t->TEST CASE: 'Test_EnterBusinessPartner'",
"result" : "Passed"
}, {
"className" : "com.fja.ipl.tools.setak.testreport.Test",
"date" : "Fri Aug 23 12:23:56 CEST 2013",
"name" : "\t\t->TEST CASE: 'Test_CheckFoundBusinessPartner'",
"result" : "Failed"
}]
}]
}


Thanks in advance for whatever answer.
  • Attachment: DS.jpg
    (Size: 33.69KB, Downloaded 227 times)
Re: mongodb-oda-birt-plugin - JSONPath [message #1116470 is a reply to message #1112860] Wed, 25 September 2013 09:54 Go to previous messageGo to next message
Eclipse UserFriend
So, are you using the out-of-the-box ODA? Or one that you're having to install that you downloaded somewhere? Let me know.
Re: mongodb-oda-birt-plugin - JSONPath [message #1116486 is a reply to message #1116470] Wed, 25 September 2013 10:09 Go to previous messageGo to next message
Eclipse UserFriend
I have it downloaded here:
http: //code.google.com/a/eclipselabs.org/p/mongodb-oda-birt-plugin/downloads/list
Re: mongodb-oda-birt-plugin - JSONPath [message #1116495 is a reply to message #1116486] Wed, 25 September 2013 10:24 Go to previous messageGo to next message
Eclipse UserFriend
Try using the MongoDB ODA that comes with BIRT 4.3. You don't need to use an external plug-in anymore. If you're not using 4.3 already, this would require that you upgrade, obviously.

[Updated on: Wed, 25 September 2013 10:26] by Moderator

Re: mongodb-oda-birt-plugin - JSONPath [message #1116768 is a reply to message #1116495] Wed, 25 September 2013 16:31 Go to previous messageGo to next message
Eclipse UserFriend
The MongoDB ODA connector distributed with BIRT 4.3 can select nested documents from a MongoDB collection.
Give it a try, and let us know of any feedback. Thanks.
Re: mongodb-oda-birt-plugin - JSONPath [message #1117184 is a reply to message #1116768] Thu, 26 September 2013 03:13 Go to previous message
Eclipse UserFriend
Hi, thanks for response.
I just tried BIRT 4.3 with such query - see picture: index.php/fa/16297/0/

In BIRT Data Explorer one cane see it - see picture: index.php/fa/16298/0/

When I place the field on report and switch to preview pane got an exception: index.php/fa/16299/0/
Previous Topic:how do I toggle visibility of column in script?
Next Topic:BIRT report 4.3 under JSF
Goto Forum:
  


Current Time: Wed Jul 23 19:21:58 EDT 2025

Powered by FUDForum. Page generated in 0.03531 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly