Ordering Data by Related Fields in a Relational Database

yuehong · 2024-11-14T02:21:23.718Z

I have a database structure that looks like this:

Warranty Claim

Consists of warranty detail fields
Customer field with a relationship to the Customer data type

Customer

Consists of all customer details

When setting up the data source with the Warranty Claim content type, how can I order it by Customer Name, which is in the Customer table? When I add a sort field, the dropdown only shows non-relationship fields from Warranty Claim.

anishgandhi3592 · 2024-11-14T05:08:55.718Z

Hey @yuehong ,

You can use the List Shifter plugin by @keith for this.

Here is how to execute a video.