Hello < Ryan> I created enum type ```enum Test Open Converte Prisma #orm-help

Hello <@UESADRKMY> I created enum type ```enum Tes...

Jemin Kothari

10/14/2021, 8:50 AM

Hello @Ryan I created enum type

Copy code

enum Test {
  Open
  Converted
  Junk
}

Jemin Kothari

10/14/2021, 8:50 AM

And when I apply ordering on this enum field it return Open first instead of Converted

Ryan

10/14/2021, 9:43 AM

What is the query that you have made for ordering?

Jemin Kothari

10/14/2021, 10:59 AM

Copy code

orderBy: {
    Test : asc
  }

Reuben Porter

10/14/2021, 11:07 AM

Will those enums not be mapped to 0, 1, 2? Potentially try re-arranging the order? I could be wrong!

Jemin Kothari

10/14/2021, 11:09 AM

Yes

Reuben Porter

10/14/2021, 11:09 AM

Did that work?

Reuben Porter

10/14/2021, 11:09 AM

Copy code

enum Test {
  Converted
  Open
  Junk
}

Jemin Kothari

10/14/2021, 11:12 AM

No, I have to update the type at db level

Jemin Kothari

10/14/2021, 11:12 AM

Using alter tabke

Jemin Kothari

10/14/2021, 11:12 AM

table

Jemin Kothari

10/14/2021, 11:14 AM

I changed the enum type order in db then it worked

🙌 1

💯 1

3 Views