Order relation array?

[conduongtong]

Question

For example I have this update:

Await prisma.post.update({ where: { id: 1 }, data: { tags: { connect: [{ id: 2 }, { id: 1 }, { id: 3 }] } } });

When I use:

await prisma.post.findFirst({ include: { tags: true } });

It will return: [1,2,3]. Event if I change database to 2,1,3, it still return 1,2,3.
How can I order by like [2,1,3] without having order field?

How to reproduce (optional)

No response

Expected behavior (optional)

Return [2,1,3]

Information about Prisma Schema, Client Queries and Environment (optional)

No response

[nurul3101]

Hello @conduongtong 👋

I don't believe it's possible without using the order field. Which database are you using?
You can do something like this, but it would still involve using order by.

const orderedIds = [2, 1, 3]; // The desired order of IDs
const result = await prisma.$queryRaw`SELECT * FROM Post WHERE id IN (${Prisma.join(orderedIds)}) ORDER BY FIELD(id, ${Prisma.join(orderedIds)})`;

Reference for $queryRaw.

[conduongtong]

Thanks for reply.
I hope there will be a feature that do not sort by default like this. I cannot create another table for all of my relationship like this.
btw I'm using Postgres

[janpio]

Related issue opened by @conduongtong: #23898