Updating many mongoDB records of a field based on a conditionRandom record from MongoDBUpdate values in array in MongoDBUpdate MongoDB field using value of another fieldHow to get the last N records in mongodb?Add new field to every document in a MongoDB collection“Large data” work flows using pandasFind MongoDB records where array field is not emptyFind field in MongoDB where field is not empty (in PHP)Why use Redux over Facebook Flux?MongoDB: How to update (hash) a field in a big collection
N.B. ligature in Latex
Can town administrative "code" overule state laws like those forbidding trespassing?
How is it possible for user's password to be changed after storage was encrypted? (on OS X, Android)
Can Medicine checks be used, with decent rolls, to completely mitigate the risk of death from ongoing damage?
Circuitry of TV splitters
What is the meaning of "of trouble" in the following sentence?
New order #4: World
How to report a triplet of septets in NMR tabulation?
Why is an old chain unsafe?
Is it possible to make sharp wind that can cut stuff from afar?
Motorized valve interfering with button?
The use of multiple foreign keys on same column in SQL Server
Why Is Death Allowed In the Matrix?
Is Social Media Science Fiction?
DOS, create pipe for stdin/stdout of command.com(or 4dos.com) in C or Batch?
Extreme, but not acceptable situation and I can't start the work tomorrow morning
How is the claim "I am in New York only if I am in America" the same as "If I am in New York, then I am in America?
A newer friend of my brother's gave him a load of baseball cards that are supposedly extremely valuable. Is this a scam?
I’m planning on buying a laser printer but concerned about the life cycle of toner in the machine
Should I join an office cleaning event for free?
What is the white spray-pattern residue inside these Falcon Heavy nozzles?
Are white and non-white police officers equally likely to kill black suspects?
Chess with symmetric move-square
Schwarzchild Radius of the Universe
Updating many mongoDB records of a field based on a condition
Random record from MongoDBUpdate values in array in MongoDBUpdate MongoDB field using value of another fieldHow to get the last N records in mongodb?Add new field to every document in a MongoDB collection“Large data” work flows using pandasFind MongoDB records where array field is not emptyFind field in MongoDB where field is not empty (in PHP)Why use Redux over Facebook Flux?MongoDB: How to update (hash) a field in a big collection
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I have few records in my Mongo DB. The currentStatus field has either of three statuses ("IDLE", "ACTIVE", "SHUTDOWN"). I want to update all records in the currentStatus field from "IDLE" or "ACTIVE" to "SHUTDOWN". I need to make sure they are not in the "SHUTDOWN" state before updating.
The field looks like this:
Tried this but didn't work.
var currentStatusActive = this.collection.find(currentStatus: "ACTIVE");
var currentStatusIdle = this.collection.find(currentStatus : "IDLE");
if(currentStatusActive.currentStatus == "ACTIVE" || currentStatusIdle.currentStatus == "IDLE")
var newStatus = $set: currentStatus: "SHUTDOWN" ;
this.collection.updateMany(newStatus, function(err,res)
if (err) throw err;
)
javascript database mongodb nosql
asked Mar 22 at 0:58
Avinash GayamAvinash Gayam
317
add a comment |
I have few records in my Mongo DB. The currentStatus field has either of three statuses ("IDLE", "ACTIVE", "SHUTDOWN"). I want to update all records in the currentStatus field from "IDLE" or "ACTIVE" to "SHUTDOWN". I need to make sure they are not in the "SHUTDOWN" state before updating.
The field looks like this:
Tried this but didn't work.
var currentStatusActive = this.collection.find(currentStatus: "ACTIVE");
var currentStatusIdle = this.collection.find(currentStatus : "IDLE");
if(currentStatusActive.currentStatus == "ACTIVE" || currentStatusIdle.currentStatus == "IDLE")
var newStatus = $set: currentStatus: "SHUTDOWN" ;
this.collection.updateMany(newStatus, function(err,res)
if (err) throw err;
)
javascript database mongodb nosql
asked Mar 22 at 0:58
Avinash GayamAvinash Gayam
317
add a comment |
I have few records in my Mongo DB. The currentStatus field has either of three statuses ("IDLE", "ACTIVE", "SHUTDOWN"). I want to update all records in the currentStatus field from "IDLE" or "ACTIVE" to "SHUTDOWN". I need to make sure they are not in the "SHUTDOWN" state before updating.
The field looks like this:
Tried this but didn't work.
var currentStatusActive = this.collection.find(currentStatus: "ACTIVE");
var currentStatusIdle = this.collection.find(currentStatus : "IDLE");
if(currentStatusActive.currentStatus == "ACTIVE" || currentStatusIdle.currentStatus == "IDLE")
var newStatus = $set: currentStatus: "SHUTDOWN" ;
this.collection.updateMany(newStatus, function(err,res)
if (err) throw err;
)
javascript database mongodb nosql
asked Mar 22 at 0:58
Avinash GayamAvinash Gayam
317
I have few records in my Mongo DB. The currentStatus field has either of three statuses ("IDLE", "ACTIVE", "SHUTDOWN"). I want to update all records in the currentStatus field from "IDLE" or "ACTIVE" to "SHUTDOWN". I need to make sure they are not in the "SHUTDOWN" state before updating.
The field looks like this:
Tried this but didn't work.
var currentStatusActive = this.collection.find(currentStatus: "ACTIVE");
var currentStatusIdle = this.collection.find(currentStatus : "IDLE");
if(currentStatusActive.currentStatus == "ACTIVE" || currentStatusIdle.currentStatus == "IDLE")
var newStatus = $set: currentStatus: "SHUTDOWN" ;
this.collection.updateMany(newStatus, function(err,res)
if (err) throw err;
)
javascript database mongodb nosql
javascript database mongodb nosql
asked Mar 22 at 0:58
Avinash GayamAvinash Gayam
317
asked Mar 22 at 0:58
Avinash GayamAvinash Gayam
317
asked Mar 22 at 0:58
Avinash GayamAvinash Gayam
317
asked Mar 22 at 0:58
Avinash GayamAvinash Gayam
317
asked Mar 22 at 0:58
Avinash GayamAvinash Gayam
317
317
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You have to wrap the filter conditions and the set target inside the mongodb updateMany function.
try
db.collection.updateMany(
"currentStatus": $in:["ACTIVE","IDLE"] ,
$set: "currentStatus" : "SHUTDOWN"
);
catch (e)
print(e);
See https://docs.mongodb.com/manual/reference/method/db.collection.updateMany/ for more explanation.
answered Mar 22 at 1:23
tnkhtnkh
220110
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55291401%2fupdating-many-mongodb-records-of-a-field-based-on-a-condition%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You have to wrap the filter conditions and the set target inside the mongodb updateMany function.
try
db.collection.updateMany(
"currentStatus": $in:["ACTIVE","IDLE"] ,
$set: "currentStatus" : "SHUTDOWN"
);
catch (e)
print(e);
See https://docs.mongodb.com/manual/reference/method/db.collection.updateMany/ for more explanation.
answered Mar 22 at 1:23
tnkhtnkh
220110
add a comment |
You have to wrap the filter conditions and the set target inside the mongodb updateMany function.
try
db.collection.updateMany(
"currentStatus": $in:["ACTIVE","IDLE"] ,
$set: "currentStatus" : "SHUTDOWN"
);
catch (e)
print(e);
See https://docs.mongodb.com/manual/reference/method/db.collection.updateMany/ for more explanation.
answered Mar 22 at 1:23
tnkhtnkh
220110
add a comment |
You have to wrap the filter conditions and the set target inside the mongodb updateMany function.
try
db.collection.updateMany(
"currentStatus": $in:["ACTIVE","IDLE"] ,
$set: "currentStatus" : "SHUTDOWN"
);
catch (e)
print(e);
See https://docs.mongodb.com/manual/reference/method/db.collection.updateMany/ for more explanation.
answered Mar 22 at 1:23
tnkhtnkh
220110
You have to wrap the filter conditions and the set target inside the mongodb updateMany function.
try
db.collection.updateMany(
"currentStatus": $in:["ACTIVE","IDLE"] ,
$set: "currentStatus" : "SHUTDOWN"
);
catch (e)
print(e);
See https://docs.mongodb.com/manual/reference/method/db.collection.updateMany/ for more explanation.
answered Mar 22 at 1:23
tnkhtnkh
220110
answered Mar 22 at 1:23
tnkhtnkh
220110
answered Mar 22 at 1:23
tnkhtnkh
220110
answered Mar 22 at 1:23
tnkhtnkh
220110
220110
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55291401%2fupdating-many-mongodb-records-of-a-field-based-on-a-condition%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
