Ordering and filtering in joined queries

[alexmakarchikov]

Hi! I need to join queries and sorting(filtering) the result. I use the codable way. How can I sort by "player.name" column for example? The code below dont work
static func fetchAllAndSortByName(_ db: Database) throws -> [PlayerInfo] { try all().sort(Column("player.name")).fetchAll(db) }

[groue]

Hello @alexmakarchikov,

The "Splitting Rows" chapters are about manually-crafted SQL queries.

It looks like your question is about the query interface requests, that you define in Swift, which generate SQL queries for you.

So check the documentation about the order method:

• In requests
• In associations

After you have read the documentation, try to apply it. And if you still can't do what you need to do, ask a detailed question (please take inspiration from the issue template).

[alexmakarchikov]

Thanks! I figured out how to do it