krishnam

I need to generate reports based merchant parameter value. If it is null/empty then report should return all the documents, otherwise the specific document that matches should be returned. Tried different things and none of them worked. Appreciated any ideas/suggestions. Thanks Code:<parameter name="state" class="java.lang.String"/><parameter name="merchant" class="java.lang.String"/><queryString language="MongoDbQuery"> <![CDATA[{'collectionName':'Merchant' , 'findQuery' : {'$and' : [ {'_id.state' : '$P!{state}'} , {'_id.merchantId : '$P!{merchant}'} ] } }]]></queryString>

Solved the issue by myself by setting the filter expression to new Boolean(true)

I have the need to generate reports based merchant parameter value. It if is null/empty then report should return all the documents, otherwise the specific document that matches the parameter value should be returned. Tried different things and none of them worked. Appreciated any ideas/suggestions. Code: <parameter name="state" class="java.lang.String"/> <parameter name="merchant" class="java.lang.String"/><queryString language="MongoDbQuery"><![CDATA[{'collectionName':'Merchant' ,"findQuery" : {"$and" : [ {"_id.state" : "$P!{state}"} , {"_id.merchantId" : "$P!{merchant}"} ] } }]]> </queryString>

Was trying to use map/reduce feature of mongodb. Both the attached reports work fine on windows 7 machine with iReport 4.5.0/4.5.1 and mongodb 2.0.0. I could see the report output being generated in PDF. but throws "The document has no pages" message on windows vista m/c with iReport 4.5.0/4.5.1 and mongodb 1.8.1/2.0.0. Not sure what was the reason. Not suspecting the os issue. In both the cases it creates the collection and stores records after executing map/reduce command but after wards it doesn't return results in second scenario. But doesn't return any results. Tried different approaches with no luck. Any ideas why is this weird behavior of working on one m/c and not others ? Is it mongodb version? Failure case : mongo db running in different drive vs ireport designer (but not suspecting this)