Ordering Data by Related Fields in a Relational Database

Need help Database
1

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.

1 Like
2

Hey @yuehong ,

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

Here is how to execute a video.