ujjwalguptaofficial / JsStore

A complete IndexedDB wrapper with SQL like syntax.

http://jsstore.net/

MIT License

849 stars 109 forks source link

or condition and array in where does not works when using within joins #356

Closed Aparnai7 closed 9 months ago

Aparnai7 commented 9 months ago

Title

or condition and array in where does not works when using within joins

Description

select({ from: "Orders", join: [{ with: 'Customers', on: 'Customers.customerId=Orders.customerId', where: [{ customerId: 87, },{ or: { customerId: 85, }, }] }, { with: 'Employees', on: 'Employees.employeeId = Orders.employeeId', }, ], where: [{ shipperId: 3 }] });

whenever we try to use "or" condition OR use array in where condition inside joins, it does not work

ujjwalguptaofficial commented 9 months ago

@Aparnai7 thanks for raising the issue, i am able to reproducing the issue and working on fixes - it seems like issue is in array query inside where.

ujjwalguptaofficial commented 9 months ago

it's fixed in v - 4.7.1, please check and let me know. Happy coding.

ujjwalguptaofficial commented 9 months ago