1

I am using a query with aggregation pipeline and want to sort the output based on a string row.
The values look like: “name-1”, “name-2”, …
If I use “$sort” I get the error message: Error running query: string indices must be integers
Is there a way to sort strings?

2

What’s the full query you’re using?

3 
{
    "collection": "virtualdevices",
    "aggregate": [
        {
            "$match": {
                "$and": [
                    {
                        "name": {
                            "$regex": "name-",
                            "$options": "ig"
                        }
                    }
                ]
            }
        },
        {
            "$group": {
                "_id": {
                    "id": "$_id",
                    "vd": "$name",
                    "serialNumber": "$serialNumber"
                }
            }
        },
        {
            "$project": {
                "_id": 0,
                "value": "$_id.id",
                "name": "$_id.vd",
                "serialNumber": "$_id.serialNumber"
            }
        }
    ]
}
4

I tried to use:

{
    "$sort": {
        "_id.name": 1
    }
},
5

Try changing it into:

{
    "$sort": [{
        "_id.name": 1
    }]
}
6 
        "$sort": [{
            "name": "name",
            "direction": 1
        }]

This worked for me!
Thank you!

7

Why is it like this, though?

8

No good reason. It just how it was implemented.