How to concatenate a derived array

D. Rattansingh

This is my Database schema:

This is retrieving the reviews sorted by creation date desc and is working:

db.films.findOne(
        { _id: ObjectId("64d69473da87c0c91ae7c596") },
        {
          title: 1,
          reviews: {
            $sortArray: { input: "$reviews", sortBy: { creationdate: -1 } },
          },
        }
      );

I tried a test here with concatenating 2 arrays from the Database and it's working:

db.films.findOne(
        { _id: ObjectId("64d69473da87c0c91ae7c596") },
        {
          title: 1,
          reviews: {
            $concatArrays: ["$reviews", "$reviews"],
          },
        }
      );

What I'm trying to do is combine the two, concatenate $reviews with the sorted reviews array from the first statement as follows:

db.films.findOne(
        { _id: ObjectId("64d69473da87c0c91ae7c596") },
        {
          title: 1,
          reviews: {
            $concatArrays: [
              "$reviews",
              $sortArray: { input: "$reviews", sortBy: { creationdate: -1 } },
            ],
          },
        }
      );

It isn't working, there's a syntax error. Could I do this? any advice?

user20042973

there's a syntax error

It would be helpful if you would provide that syntax error. By pasting your query into mongoplayground, we can see from this example that the error is:

Unknown type: '$sortArray: {'

This is because that second argument to $concatArrays (the one in which you are modifying the earlier array) needs to itself be an object. Wrapping it in curly brackets resolves the issue:

db.films.findOne({
  _id: ObjectId("64d69473da87c0c91ae7c596")
},
{
  title: 1,
  reviews: {
    $concatArrays: [
      "$reviews",
      {
        $sortArray: {
          input: "$reviews",
          sortBy: {
            creationdate: -1
          }
        }
      }
    ]
  }
})

Playground demonstration

It's unclear if you want to duplicate the reviews array as is written in your question, but the answer to the question itself is "yes, you can concatenate the two arrays by resolving your syntax error."

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2023-09-5

Comments

0 comments

TOP Ranking

Article

How to concatenate a derived array

How to concatenate a derived array

pump.io port in URL

How to import an asset in swift using Bundle.main.path() in a react-native native module

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

Double spacing in rmarkdown pdf

SQL Server : need add a dot before two last character

Ambiguous use of 'init' with CFStringTransform and Swift 3

Resetting Value of <input type="time"> in Firefox

Retrieve Element Tag Value XML Using Bash

How to pass data to the ng2-bs3-modal?

JWT gives JsonWebTokenError "invalid token"

How to update azerothcore-wotlk docker container

C++ 16 bit grayscale gradient image from 2D array

redirect your computer port to url

Capybara Selenium Chrome opens About Google Chrome

mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on '127.0.0.1:3306' (111 Connection refused)

How to make thrown errors visible outside of a Promise?

JMeter: Why get error when try to save test plan

Should you provide dependent libraries in client jar?

Issue making model pop up onPress of flatlist

Message: element not interactable on accessing a tag python

Calling Doctrine clear() with an argument is deprecated