[Beginner] complex "where" clause
Hi. I'm getting from frontend app following (quite complex) filtering criteria:
As it comes from a data grid, a user can specify any criterias basing on available columns
I need to convert these to proper params of where() method. Is it possible with drizzle at all? If so, can someone share some tips how to start? Or maybe the better option is to convert it to plain sql...
TIA
[[["documentDate",">=","2023-11-23T23:00:00.000Z"],"and",["documentDate","<","2023-11-24T23:00:00.000Z"]],"and",[["inOut","contains","FV"],"or",["customerId","contains","FV"],"or",["documentTypeId","contains","FV"],"or",["documentNo","contains","FV"]]]As it comes from a data grid, a user can specify any criterias basing on available columns
I need to convert these to proper params of where() method. Is it possible with drizzle at all? If so, can someone share some tips how to start? Or maybe the better option is to convert it to plain sql...
TIA
