Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Dynamic query with mongodb in BIRT
Dynamic query with mongodb in BIRT [message #1455451] Wed, 29 October 2014 11:36 Go to next message
Tadeo Julián Segarra is currently offline Tadeo Julián SegarraFriend
Messages: 1
Registered: October 2014
Junior Member
I have to make a birt report with 1 parameter which should be used in query. The parameter is a string.

I tried to do it in beforeOpen dataset as indicated for sql queries, but it has not worked.

I write in beforeOpen expression dataset:

this.queryText = '{
"findQueryExpr": { "ref": "'+params["ref"].value+'" } ,
"operationType" : "FIND" ,
"collectionName" : "events",
"queryReadPreference" : "secondary" ,
"selectedFields" : [ "ref" , "sts" , "rts" , "c.value" , "c.type" , "c.quality" , "r.value" , "r.type" , "r.quality"]

And the query is throwing on the total number of documents in the collection regardless of the parameters.

It is possible to make mongo query in Birt with parameters?
Re: Dynamic query with mongodb in BIRT [message #1463035 is a reply to message #1455451] Thu, 06 November 2014 06:25 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

I've not tried it, but if you create a standard query that you know works using the query builder, then, look at the XML source to see the structure of the query, it might help you out in changing the query. Let me know.


Developer Evangelist, Silanis
Re: Dynamic query with mongodb in BIRT [message #1496281 is a reply to message #1455451] Tue, 02 December 2014 23:15 Go to previous message
Jose Patricio Villarreal is currently offline Jose Patricio VillarrealFriend
Messages: 2
Registered: November 2014
Junior Member
Tadeo, can you tell me if you could resolve this issue? If so, how did you did it... I'm having the same issue...
Previous Topic:genReport.bat usage
Next Topic:BIRT and embedded fonts
Goto Forum:

Current Time: Tue Jul 23 16:01:57 GMT 2024

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

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

Back to the top