2 / 4
Jul 2024

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=“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

Hi , @florence023 thanks for the response but its not working,
in my case this format is working but only for specific value like true / false not for the $exists operation

{ "$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" } } ] }
6 months later

To include the level1Points, level2Points, and level3Points fields in your match expression, use the $exists: true operator. This will ensure documents with these fields are included, alongside the checks for level1, level2, and level3. You can always listen to Spotify while working on this.