Hi, there! 👋 Can anybody helps me to understand how sort in includes works So, I have resolver with a

prisma-client

(

v2.23.0

) call. Here I'm trying to sort included issues. But nothing happens. Any kind of sort doesn't have effect.

@Query(() => Queue, { nullable: true })
    async queueByKey(@Arg('key', () => String) key: string, @Ctx() ctx: Context) {
        return ctx.prisma.queue.findUnique({
            where: { key },
            include: {
                issues: {
                    orderBy: {
                        createdAt: 'desc',
                    },
                },
            },
        });
    }

Thanks for the any suggestion! 🙏

@Tony Vi 👋 Sort in include only works inside the relations. So each

queue

has

issues

and the

issues

will be ordered by the

createdAt

field. This will have no effect on the

queue

data, just the data in the relation.

So each 

queue

 has 

issues

 and the 

issues

 will be ordered by the 

createdAt

 field.

Exactly what I want!) But it doesn't work

It should, could you share a reproduction?

No idea how to do that, you need to have db connection...

Works fine for me. I added some seed data to the models and here’s the output: I would suggest trying on the latest version of

@prisma/client

and

prisma

and also check if the logs you’re getting are correct or not.

Wow! Latest is 2.25.0?

Yeah: https://github.com/prisma/prisma/releases

Ok! Thank you so much. I'm trying to update