[quote=“Amit_Yadav5, post:1, topic:288551, full:true”]Spotify Pie
this is my current match expression

{
  "$or": [
    {
      "updateDescription.updatedFields": {
        "usdcLiquidation.level1": "true"
    }
    },
    {
      "updateDescription.updatedFields": {
        "usdcLiquidation.level2": "true"
    }
    },
    {
      "updateDescription.updatedFields": {
        "usdcLiquidation.level3": "true"
    }
    },
    {
      "updateDescription.updatedFields": {
        "usdtLiquidation.level1": "true"
    }
    },
    {
      "updateDescription.updatedFields": {
        "usdtLiquidation.level2": "true"
    }
    },
    {
      "updateDescription.updatedFields": {
        "usdtLiquidation.level3": "true"
    }
    },
    {
      "updateDescription.updatedFields": {
        "btcLiquidation.level1": "true"
    }
    },
    {
      "updateDescription.updatedFields": {
        "btcLiquidation.level2": "true"
    }
    },
    {
      "updateDescription.updatedFields": {
        "btcLiquidation.level3": "true"
    }
    }
  ] 
}

I have one more field which is usdcLiquidation.level1Points and so for all the fields.
I want to add this in the match expression but not sure how to do ?
[/quote]

Hello,

To add the field usdcLiquidation.level1Points to your existing match expression, you can use the $or operator along with the $exists operator. Here’s how you can modify your expression:

{
  "$or": [
    {
      "updateDescription.updatedFields.usdcLiquidation.level1": "true"
    },
    {
      "updateDescription.updatedFields.usdcLiquidation.level2": "true"
    },
    {
      "updateDescription.updatedFields.usdcLiquidation.level3": "true"
    },
    {
      "updateDescription.updatedFields.usdtLiquidation.level1": "true"
    },
    {
      "updateDescription.updatedFields.usdtLiquidation.level2": "true"
    },
    {
      "updateDescription.updatedFields.usdtLiquidation.level3": "true"
    },
    {
      "updateDescription.updatedFields.btcLiquidation.level1": "true"
    },
    {
      "updateDescription.updatedFields.btcLiquidation.level2": "true"
    },
    {
      "updateDescription.updatedFields.btcLiquidation.level3": "true"
    },
    {
      "updateDescription.updatedFields.usdcLiquidation.level1Points": { "$exists": true }
    }
  ]
}

By adding the last condition { "updateDescription.updatedFields.usdcLiquidation.level1Points": { "$exists": true } }, you ensure that documents with the field usdcLiquidation.level1Points are also considered in your query. This way, you include all the specified fields in your match expression.

Hope this work for you.
Best regards,
florence023