8 replies

NULLS LAST in orderBy

I am trying to create a query and the only way i have been able to order by with nulls last

is this:

    const rows = await db
    .select().from(s.webshop)
    .leftJoin(s.searchRank, eq(s.webshop.id, s.searchRank.webshopId))
    .where(and(
        eq(s.webshop.enabled, true),
        eq(s.webshop.disableSeoPage, false).if(onlyFetchIfSeoAllowed)
    ))
    .orderBy(desc(s.searchRank.usage), sql`nulls last`)

    const rows = await db
    .select().from(s.webshop)
    .leftJoin(s.searchRank, eq(s.webshop.id, s.searchRank.webshopId))
    .where(and(
        eq(s.webshop.enabled, true),
        eq(s.webshop.disableSeoPage, false).if(onlyFetchIfSeoAllowed)
    ))
    .orderBy(desc(s.searchRank.usage), sql`nulls last`)

so my question is: is there a way to do this without using an escape hatch?

Drizzle Team•2y ago•

8 replies

TSK_SMILEY

NULLS LAST in orderBy

I am trying to create a query and the only way i have been able to order by with nulls last

is this:

    const rows = await db
    .select().from(s.webshop)
    .leftJoin(s.searchRank, eq(s.webshop.id, s.searchRank.webshopId))
    .where(and(
        eq(s.webshop.enabled, true),
        eq(s.webshop.disableSeoPage, false).if(onlyFetchIfSeoAllowed)
    ))
    .orderBy(desc(s.searchRank.usage), sql`nulls last`)

    const rows = await db
    .select().from(s.webshop)
    .leftJoin(s.searchRank, eq(s.webshop.id, s.searchRank.webshopId))
    .where(and(
        eq(s.webshop.enabled, true),
        eq(s.webshop.disableSeoPage, false).if(onlyFetchIfSeoAllowed)
    ))
    .orderBy(desc(s.searchRank.usage), sql`nulls last`)

so my question is: is there a way to do this without using an escape hatch?

NULLS LAST in orderBy

Similar Threads

NULLS LAST in orderBy

Similar Threads

Similar Threads

Similar Threads