21 replies

Using `$dynamic()` to enhance where clause

I have a function like:

export const applyFilter = (qb: SQLiteSelect, paging: Paging, filter: string | undefined) => { .. }

export const applyFilter = (qb: SQLiteSelect, paging: Paging, filter: string | undefined) => { .. }

which adds

limit

limit

and

offset

offset

and also

where

where

using

qb.where(..)

qb.where(..)

.

This works great, but now I have the use case the

qb

qb

received already contains a where clause.
But the

qb.where(..)

qb.where(..)

overwrites it unfortunately.

Is there a way to merge them instead, if the

qb

qb

already has a where?