Here I just need to look up three tables first need to get all subjects from the subject table according to classid and boardid then from the content table we need to get all topic and content details and group…
When an optional key in a collection is queried , performance varied with respect to the following two queries. Good response : When it queried with a specific value - a value other than null, it resulted good response time.…
I am trying to find a way to query a mongodb collection: all documents whose state value of 'running' is also the latest entry inside the 'history' array should be returned. I was able to do this in C# with…
My sample document is [ { "id": 1234, "close": "11100", "products": [ { "productId": 111 } ] }, { "id": 1235, "close": "10101", "products": [ { "productId": 111 } ] } ] I wanted to fetch the documents only if…
I have the following mongo model: { "_id" : "5f5a1c1f6976570001783ab7", "date" : NumberLong(1590624000), "source" : "here", } I would like to have the number of documents, group by date, that have source field at here value for example: { "date"…
I have a collection of documents where each of the documents may have an array of teamsIds like: { "id": 1, "teamsIds": ["team_a", "team_b"] } I'm trying to write an Aggregation (doing $match stage before) that will $project the documents…
Here see this Collection here have a record with createdAt with 14Feb and one with 16Feb, Now querying an aggregation on the collection such as I want to add an document of 15Feb as it was missing in collection with…
I have a document like below { "name" :{ "English": "AA", "Bengali": "BB", "Gujarati": "CC", "Hindi": "DD"} } can I filter it based on the keys e.g. need to filter only on 'English' and 'Hindi' so the output should be…
I have a sample data like this : db.contact.insert( [ { _id: 1, name: 'John legend',age: 35}, { _id: 2, name: 'michael Ava',age: 40}, { _id: 3, name: 'Tom holand',age: 20}, { _id: 4, name: 'Frido pex',age: 25}, { _id:…
I try to convert a postgreSQL query (from the nextjs dashboard tutorial from vercel) to a mongodb query using aggregate and $lookup. I know how to aggregate multiple collections and filter for one parameter. And how to query one collection…