When we are firing the below query on jsstore DB the multiple ‘!’ values are not executed; ideally the result was expected that it should return data of all countries whose name not brazil & mexico. Any way to achieve this?
select({
from: ‘Customers’,
where: {
country: {
regex: /!mexico|!brazil/i
}
}
})
Multiple not conditions to be added in where clause like notin
New contributor
Pushkaraj Khamkar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.