Sort by smart field that includes value from a belongsTo relationship

Please be sure of your agent type and version and pick the right documentation accordingly.

Node.js

This is the documentation of the forest-express-sequelize and forest-express-mongoose Node.js agents that will soon reach end-of-support.

forest-express-sequelize v9 and forest-express-mongoose v9 are replaced by @forestadmin/agent v1.

Please check your agent type and version and read on or switch to the right documentation.

Ruby on Rails

Python

PHP

Sort by smart field that includes value from a belongsTo relationship

Context: As a user I want to be able to sort records based on a smart field where the smart field includes data from the current record's parent.

Example: Here I have a model orders that has a belongsTo relationship with the customers model.

I have a smart field in the orders model called customer email that returns the value of the parent customer's email field. I want to sort the orders by the customer email smart field.

Implementation

forest/orders.js

const { collection } = require('forest-express-sequelize');
const models = require('../models');

collection('orders', {
  actions: [],
  fields: [
    {
      field: 'customer email',
      get: (order) =>
        models.customers
          .findByPk(order.customer.dataValues.id)
          .then((customer) => customer.email),
      isSortable: true,
    },
  ],
  segments: [],
});

routes/orders.js

router.get(
  '/orders',
  permissionMiddlewareCreator.list(),
  (request, response, next) => {
    if (request.query.sort.includes('customer email')) {
      request.query.sort = request.query.sort.includes('-')
        ? '-customer.email'
        : 'customer.email';
    }
    next();
  }
);