Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » mongodb-oda-birt-plugin - JSONPath
mongodb-oda-birt-plugin - JSONPath [message #1112860] Fri, 20 September 2013 09:17 Go to next message
Pavol Sestak is currently offline Pavol SestakFriend
Messages: 3
Registered: September 2013
Junior Member
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 184 times)
Re: mongodb-oda-birt-plugin - JSONPath [message #1116470 is a reply to message #1112860] Wed, 25 September 2013 13:54 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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.

Michael

Developer Evangelist, Silanis
Re: mongodb-oda-birt-plugin - JSONPath [message #1116486 is a reply to message #1116470] Wed, 25 September 2013 14:09 Go to previous messageGo to next message
Pavol Sestak is currently offline Pavol SestakFriend
Messages: 3
Registered: September 2013
Junior Member
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 14:24 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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.

Michael

Developer Evangelist, Silanis

[Updated on: Wed, 25 September 2013 14:26]

Report message to a moderator

Re: mongodb-oda-birt-plugin - JSONPath [message #1116768 is a reply to message #1116495] Wed, 25 September 2013 20:31 Go to previous messageGo to next message
Linda ChanFriend
Messages: 845
Registered: July 2009
Senior Member
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 07:13 Go to previous message
Pavol Sestak is currently offline Pavol SestakFriend
Messages: 3
Registered: September 2013
Junior Member
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: Tue Oct 26 10:04:18 GMT 2021

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

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

Back to the top