I have the following T-SQL query :
SELECT year, COUNT(*) FROM publis
WHERE publisher LIKE ‘%Springer%’
I made this query :
db.publis.aggregate([{"$group" : {_id:"$year", count:{$sum:1}}}])
How can I include the WHERE …
I’ve problem to find the good document search request do find all documents containing in their ‘name’ field all the specified values.
I’ve this document:
{
"_id" : ObjectId("607c1caa4b2964d0185301ff"),
"nb…
I’m trying to round the average salary to 2 decimal places. I’m stumped, I can get either everyones salary to 2 decimal places
db.employees.aggregate([{$project: {_id: null, ’roundedSal’:{$round: [{$avg: ‘$salary’}]}}}])
which returns
{ …
I am trying to fetch some data within the range using gt and lt filter in mongodb but it’s behaving strangely and I don’t understand why it’s containing the data below the range. Is it because the field is string? Also, If I am putting som…
I want to update document with two new "key: value" pair in collection when a logged in user submits a single input field in collection that appears like this:
_id:60796d35822f7c0004647717
name:"<username>"
email:…
java.lang.NoSuchMethodError: kotlinx.coroutines.channels.LinkedListChannel: method ()V not found
this is my database.kt
private val client = KMongo.createClient().coroutine
private val database = client.getDatabase("PestaDanDagangD…
I am trying to use $gte in aggregation based on property from aggregation in Nodejs.
const twelveHours = 12 * 60 * 60 * 1000;
const pipeline = [
{ $addFields: {
twelveHoursBeforeStart: { $subtract: [‘$startDate’, twelveHours] } } //…
One of the shards overflowed and crashed. Now I am trying to repair it, but it cannot repair it because no space left, see below.
2021-04-16T16:32:09.402+0000 W STORAGE [initandlisten] Failed to start up WiredTiger under any compatibilit…
I am trying to connect to a MongoDB to a nodejs. I have the MongoDB running and I have an ENV file with a connection string variable. I just don’t know what to set the string to connect the data I created to the data.
Terminal:
connecting …
I have a MongoDB collection called users with documents that look like:
{
_id: ObjectId(‘123’),
username: "abc",
avatar: "avatar/long-unique-random-string.jpg",
connections: [ObjectId(‘abc’), ObjectId(‘xyz’), Ob…
I have created a project using ReactJS that is utilizing mongoDB as a database. I am trying to return a list of the NAME of all users from the Users collection in mongoDB that have a completionStatus (which is an attribute in the users col…
We use oplog collection(that is present in local database) in our code to check if an event happens on a specific db and fire an event in our code.But,as aws document db doesn’t support oplog as mentioned in "https://docs.aws.amazon.c…
I need to group at an array named location by the same coordinates field from both engagements and broadcastreports. Also if one coordinate exist in one but not on the other, It should be included anyway.
In that array I need to include a …
I want to require field depend on other field value; I have field paypaleEmail , I want it to be required when field role is "particular" otherwise not required.
paypalEmail: {
type: String,
required: function ()…
Need to download the all files from fs.files / fs.chunks in mongodb version 2.2 to the local directory.
Please suggest on this.
I want to update the record of a nested document, my document looks like this:
{
_id:60753fd9b249ad0dfa1eeb48
name:"Random Name 1"
email:"randomname1@zmel.kom"
likings:[
breakfast:{
e…
I learning how to create a to-do list web app. I encounter some problems when I want to add some new items into custom list, my console log this warnings: Cannot read property ‘items’ of null.
Cannot read property ‘items’ of null
Another p…
SO i have been following this tutorial by geeksforgeeks here is the link: https://www.geeksforgeeks.org/upload-and-retrieve-image-on-mongodb-using-mongoose/ but it shows how to upload one image at once, if i want to upload multiple images …
Code for argon2:
const usercheck = userModel.findOne({
username: req.body.username
})
const pwcheck = userModel.findOne({
password: mongoose.Query
})
if(!usercheck) return res.status(400).json({success: false, message: "User…
Is there any working snippet of file-upload to mongoDB using multer in MERN stack, with latest multer npm package.