Show inner objects as columns

Support Usage Support
1

Hello,

Very new to redash and loving it so far.

We have a mongo db and use aggregate function to join collections. The ‘as’ part of the aggregate ‘lookup’ returns an object in a column labelled ‘myJoin’ in the format below

{"_id":“5ddb771d9158ef53bfd6823c”,“historyId”:“ctV4bd3w67m”,“createdOn”:“2019-11-25T06:39:25”,"__v":0}]

How do I show createdOn and historyId as seperate columns in the table visualization? Am using this as a query currently:

{
    "collection": "players",
    "aggregate": [
        {"$lookup": {
            "from": "history",
            "localField": "pid",
            "foreignField": "pid",
            "as": "myJoin"
        }},
        {"$limit": 10}
        ]
}
2

Our doc page mentions using fields to control the projection in MongoDB. What happened when you tried this?

3

‘Fields’ only show the columns which are individually shown in the json response.

The response that we get from the above query is something like this:

_id   |   pid   | ... |   myJoin
234       47              {"_id": 737, "historyId":"s23","createdOn":"2019-11-25","_v":0}

How to show the columns in the myJoin response as seperate columns in the table?

4

¿Did you find a way to fix this?