I am trying to update cross collection update, for example I have two collections, One collection name is users and another collection name is user_businesses. Below is the sample data of both the collections. user collection data: { _id: ObjectId("64a6b0f5af3af7f59a05ba33"), id: 134, display_id: ‘PRM-SRL-000001348’, client_emp_code: ”, entity_code: ”, user_type: ‘candidate’, role: ”, user_account_type: ”, business_id:… Read More mongodb cross collection update object_id

I’m trying for mongo db to show me only the pokemons that are Grass or Water trype, but it won’t let me filter it. $or needs to be an array Is there another way to filter an or? >Solution : Make it an array using brackets []: $or: [{Type_1: "Water"}, {Type_1: "Grass"}] Documentation for $or… Read More $or in mongodb compass

I am trying to query data in MongoDB compass GUI based on multiple values using $in. My query is this – {category : {[$in: [‘a012′,’b23c’,’5870T’]}} I want to query these values with case insensitive option i. The operator $in also doesn’t accept regex expressions as per documentation. What would be the correct query with the… Read More How to query your data in mongoDB compass with case insensitive option?

So I try to import a json file in a database {"name":"Mark", "age":"25" } When I try to import the file I get it back like 0:"M" 1:"a" 2:"r" 3:"k" _id:objectId(‘etc’) and then inside a whole other element _id:objectId(‘etc’) value:25 The id is supposed to be there because i am using uuid but is the… Read More mongoDB compass database makes every letter a new element

I want to filter the array object based on value provided. I am using following query in Filter text box and along with projection. Seems like there filter is not getting applied. I also tried following but unfortunately array is not getting filtered { MissingPersonIds : {$elemMatch: { PhotoId : ‘2 – Copy (3).jpg’}} }… Read More MongoDB Compass: Filter query on array object is not working

This is the sample of my mongodb document( try to use jsonformatter.com to analyse it): {"_id":"6278686","playerName":"Rohit Lal","tournamentId":"197831","score":[{"_id":"1611380","runsScored":0,"ballFaced":0,"fours":0,"sixes":0,"strikeRate":0,"oversBowled":0,"runsConceded":0,"economyRate":0,"wickets":0,"maiden":0,"howToOut":"-","catches":["Mohit Mishra"],"stumping":[],"runout":[],"participatedRunout":[]},{"_id":"1602732","runsScored":0,"ballFaced":0,"fours":0,"sixes":0,"strikeRate":0,"oversBowled":0,"runsConceded":0,"economyRate":0,"wickets":0,"maiden":0,"howToOut":"-","catches":[],"stumping":[],"runout":[],"participatedRunout":[]},{"_id":"1536514","runsScored":1,"ballFaced":3,"fours":0,"sixes":0,"strikeRate":33.33,"oversBowled":0,"runsConceded":0,"economyRate":0,"wickets":0,"maiden":0,"howToOut":"run out Sameer Baveja","catches":[],"stumping":[],"runout":[],"participatedRunout":[]},{"_id":"1536474","runsScored":2,"ballFaced":7,"fours":0,"sixes":0,"strikeRate":28.57,"oversBowled":0,"runsConceded":0,"economyRate":0,"wickets":0,"maiden":0,"howToOut":"c Rajesh b Prasad Naik","catches":[],"stumping":[],"runout":[],"participatedRunout":[]},{"_id":"1536467","runsScored":0,"ballFaced":0,"fours":0,"sixes":0,"strikeRate":0,"oversBowled":0,"runsConceded":0,"economyRate":0,"wickets":0,"maiden":0,"howToOut":"-","catches":[],"stumping":[],"runout":[],"participatedRunout":[]},{"_id":"1500825","runsScored":0,"ballFaced":0,"fours":0,"sixes":0,"strikeRate":0,"oversBowled":0,"runsConceded":0,"economyRate":0,"wickets":0,"maiden":0,"howToOut":"-","catches":[],"stumping":[],"runout":[],"participatedRunout":[]},{"_id":"1461428","runsScored":18,"ballFaced":6,"fours":1,"sixes":2,"strikeRate":300,"oversBowled":0,"runsConceded":0,"economyRate":0,"wickets":0,"maiden":0,"howToOut":"not out","catches":[],"stumping":[],"runout":[],"participatedRunout":[]},{"_id":"1461408","runsScored":0,"ballFaced":1,"fours":0,"sixes":0,"strikeRate":0,"oversBowled":0,"runsConceded":0,"economyRate":0,"wickets":0,"maiden":0,"howToOut":"c Sudhir b Vinay Kasat *vk*","catches":[],"stumping":[],"runout":[],"participatedRunout":[]},{"_id":"1451175","runsScored":0,"ballFaced":0,"fours":0,"sixes":0,"strikeRate":0,"oversBowled":0,"runsConceded":0,"economyRate":0,"wickets":0,"maiden":0,"howToOut":"-","catches":[],"stumping":[],"runout":[],"participatedRunout":[]},{"_id":"1451146","runsScored":0,"ballFaced":0,"fours":0,"sixes":0,"strikeRate":0,"oversBowled":0,"runsConceded":0,"economyRate":0,"wickets":0,"maiden":0,"howToOut":"-","catches":[],"stumping":[],"runout":[],"participatedRunout":[]},{"_id":"1392796","runsScored":0,"ballFaced":1,"fours":0,"sixes":0,"strikeRate":0,"oversBowled":0,"runsConceded":0,"economyRate":0,"wickets":0,"maiden":0,"howToOut":"c †Vinay Kedia b Lalit","catches":[],"stumping":[],"runout":[],"participatedRunout":[]}],"__v":0} I want to sum the runsScored field of all objects inside score array. I know, I can achieve it using… Read More How to sum a particular number field present in all objects inside an array in mongodb document