I’m working with node and mongo 5. I am trying to select the field “TOTAL VALUE” with a value other than ‘$0.00’ . I think I’m able to select for ‘$0.00’ with:
{'TOTAL DUE': {$regex: /$0./}}
as in the screenshot. However trying to negate this with:
{'TOTAL DUE': {$not :{$regex: /$0./}}}
gives the entire data set (including when TOTAL DUE does not exist),
How can I get this working?