MongoDB move array element

Question

Suppose I have a collection in MongoDB with the following schema:

{
    "_id": ObjectID,
    "Entries": [
        {
            "_id": ObjectID,
            "Content": string
        }
    ]
}

Now I want to edit the "Content" field of an element from the array "Entries" and then move that element to the first index - zero - so that the array is sorted descending by when the elements were last changed. Can this be accomplished in an 'atomic' query that I can put in one db.collection.update?

If not, should I use say a UNIX timestamp and then just sort by that when querying? Is the performance difference noticable?

profesor79 · Accepted Answer · 2016-06-25 22:29:28Z

0

If you are using objectId inside your array, then part of this id is a timestamp.

That means you can always determine when field was created. If you need to deal with last update - then timestamp field will solve this problem, as I personally will not relay on array position.

See more about objectID and python here

answered Jun 25, 2016 at 22:29

profesor79

9,5033 gold badges36 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MongoDB move array element

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related