How to sort nested JSON field in sequelize

Question

I'm trying to order TabsTemplate model based on the sequence field however, ordering is not working.

Routes

/* Get Manufacturer Tabs List */
router.get('/', function(req, res) {
  var manufacturer_id = req.params.manufacturer_id;
  models.Manufacturer.findAll({
    where: {
      id: manufacturer_id
    },
    include: [{
        model: models.TabsTemplate,
        order: [[models.sequelize.json("ManufacturerTab.sequence"), 'DESC']]
    }]
  }).  
  then(function(manufacturer_tabs) {  
      res.status(200).json(manufacturer_tabs);  
  }, function(error) {  
      res.status(500).send(error);  
  });  
});

Data

[
    {
        "id": 1,
        "manufacturer_name": "Brand",
        "manufacturer_logo_url": "/assets/img/brand-logo.jpg",
        "manufacturer_archived_status": false,
        "createdAt": "2018-12-06T15:06:01.703Z",
        "updatedAt": "2018-12-06T15:06:01.703Z",
        "TabsTemplates": [
            {
                "id": 1,
                "tab_name": "Tab 1",
                "createdAt": "2018-12-06T15:06:01.684Z",
                "updatedAt": "2018-12-06T15:06:01.684Z",
                "ManufacturerTab": {
                    "manufacturerId": 1,
                    "tabsTemplateId": 1,
                    "sequence": 2,
                    "createdAt": "2018-12-06T15:06:01.707Z",
                    "updatedAt": "2018-12-06T15:06:01.707Z"
                }
            },
            {
                "id": 2,
                "tab_name": "Tab 2",
                "createdAt": "2018-12-06T15:06:01.684Z",
                "updatedAt": "2018-12-06T15:06:01.684Z",
                "ManufacturerTab": {
                    "manufacturerId": 1,
                    "tabsTemplateId": 2,
                    "sequence": 1,
                    "createdAt": "2018-12-06T15:06:01.707Z",
                    "updatedAt": "2018-12-06T15:06:01.707Z"
                }
            },
            {
                "id": 3,
                "tab_name": "Tab 3",
                "createdAt": "2018-12-06T15:06:01.684Z",
                "updatedAt": "2018-12-06T15:06:01.684Z",
                "ManufacturerTab": {
                    "manufacturerId": 1,
                    "tabsTemplateId": 3,
                    "sequence": 3,
                    "createdAt": "2018-12-06T15:06:01.707Z",
                    "updatedAt": "2018-12-06T15:06:01.707Z"
                }
            },
            {
                "id": 4,
                "tab_name": "Tab 4",
                "createdAt": "2018-12-06T15:06:01.684Z",
                "updatedAt": "2018-12-06T15:06:01.684Z",
                "ManufacturerTab": {
                    "manufacturerId": 1,
                    "tabsTemplateId": 4,
                    "sequence": 4,
                    "createdAt": "2018-12-06T15:06:01.707Z",
                    "updatedAt": "2018-12-06T15:06:01.707Z"
                }
            }
        ]
    }
]

oderring on id is working order: [['id', 'DESC']] ? or its just issue with json datatype ordering ? — Vivek Doshi
– Vivek Doshi, Commented Dec 10, 2018 at 13:40
@VivekDoshi Yes, order: [['id', 'DESC']] is working however, the issue arises when trying to specify nested object ManufacturerTab.sequence — Rahul Dagli
– Rahul Dagli, Commented Dec 10, 2018 at 13:44
Then try this one : order: [[models.sequelize.col("ManufacturerTab->>'sequence'"), 'DESC']] — Vivek Doshi
– Vivek Doshi, Commented Dec 10, 2018 at 13:56
Thanks, I made some modifications to the above and now its working: order: [[models.sequelize.col("TabsTemplates->ManufacturerTab.sequence"), 'DESC']], — Rahul Dagli
– Rahul Dagli, Commented Dec 10, 2018 at 14:08

Vivek Doshi · Accepted Answer · 2018-12-10 14:11:28Z

3

You can use models.sequelize.col instead of models.sequelize.json like :

[models.sequelize.col("TabsTemplates->ManufacturerTab.sequence"), 'DESC']

answered Dec 10, 2018 at 14:11

Vivek Doshi

58.8k12 gold badges120 silver badges126 bronze badges

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

Collectives™ on Stack Overflow

How to sort nested JSON field in sequelize

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