Query with where returns all records when where condition is undefined about denodb HOT 2 CLOSED

I found the line that is causing is it. It just skips undefined 🤔.

for (const [field, value] of Object.entries(fieldOrFields)) {
        if (value === undefined) {
          continue;
        }

from denodb.

Hey Fortunat,

Sorry it took me awhile to get back to you!

I can finally say "it is a feature" because it is indeed intended behaviour.

Just ask yourself: "is it worth making a SQL query if no iso code is provided?"

In your case, I think the best option would be to check for isoCode being undefined and if it is, not making the query. I don't know exactly what is your use case here, but I believe you don't want to query anything if it is undefined.

Even from a developer perspective, if isoCode could be undefined, it should appear in your code because this is not very common.

I hope my explanation makes sense to you. If it doesn't, please do not hesitate to let me know!

Have a great day

from denodb.