Skip to main content



      Home
Home » Archived » BIRT » Dynamic query with mongodb in BIRT
Dynamic query with mongodb in BIRT [message #1455451] Wed, 29 October 2014 07:36 Go to next message
Eclipse UserFriend
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 01:25 Go to previous messageGo to next message
Eclipse UserFriend
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.
Re: Dynamic query with mongodb in BIRT [message #1496281 is a reply to message #1455451] Tue, 02 December 2014 18:15 Go to previous message
Eclipse UserFriend
Tadeo, can you tell me if you could resolve this issue? If so, how did you did it... I'm having the same issue...
Thanks
Previous Topic:genReport.bat usage
Next Topic:BIRT and embedded fonts
Goto Forum:
  


Current Time: Mon Mar 24 03:53:26 EDT 2025

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

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

Back to the top