Jump to content

Is there a way to write conditional queryString for jrxml on Jaspersoft?


brkulu.06

Recommended Posts

I wrote this `queryString` but I want to convert it to conditional statement like `defaultValueExpression`

Here's my case;

    <queryString language="MongoDbQuery">
            <![CDATA[{
    'collectionName':'scheduler',
        findQuery : {
          $and : [
            { 'action': { $nin : ['retry', 'retryOnce']},
            'payload.measurement.metricIdentifier' :  'X'
            $P!{whereClauseForGeriOdeme}
            $P!{whereClauseForHAB}
            $P!{whereClauseForStartDate} $P!{whereClauseForEndDate} $P!{whereClauseForArizaId} $P!{whereClauseForServiceNo} $P!{whereClauseForSiebelCustomerId}  $P!{whereClauseForServiceType} $P!{whereClauseForAccessType} $P!{whereClauseForTaahhutSure}}
          ]
        }
    }]]>

As I said, I want to send query statement to Mongodb if the statement is true, otherwise don't send query to db in vain.

Thanks for help!

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...