Build queries dynamically with conditions.

How to build query on the basis of if-else conditions? I have tried doing it as below

let dbQuery = db.select().from(orders).where(and(eq(orders.organizationId, orgId), ne(orders.orderStatus , "CART"), eq(orders.id, Number(query))));

let dbQuery = db.select().from(orders).where(and(eq(orders.organizationId, orgId), ne(orders.orderStatus , "CART"), eq(orders.id, Number(query))));

if( status ){
            if(status == "COMPLETE")
                dbQuery.where(eq(orders.orderStatus, "COMPLETE"));
            else if(status == "PROCESSING")
                dbQuery.where(eq(orders.orderStatus, "PROCESSING"));
            else if(status == "CANCELLED")
                dbQuery.where(eq(orders.orderStatus, "CANCELLED"));
        }

if( status ){
            if(status == "COMPLETE")
                dbQuery.where(eq(orders.orderStatus, "COMPLETE"));
            else if(status == "PROCESSING")
                dbQuery.where(eq(orders.orderStatus, "PROCESSING"));
            else if(status == "CANCELLED")
                dbQuery.where(eq(orders.orderStatus, "CANCELLED"));
        }

But the where conditions don't seem to add and the result is returned without them.

2 Replies

Andrii Sherman•2y ago

Check this thread https://discord.com/channels/1043890932593987624/1109091751341342820

SPS | ShootmailOP•2y ago

Thanks, it worked!

Gaming

Programming

Build queries dynamically with conditions.