Hi, I have a documents with fields like “oldQty” and “newQty”. These are optional fields. Now I want to fetch the documents where “oldQty” is not equal to “newQty”(If any field having value should also come in result i.e one field having value another is missing). Here I tried with below query, but getting documents only these two fields are not missing.
select * FROM
DataBaseWHERE type = ‘inventory’ AND (
oldQtyis not missing or
newQtyis not missing) AND (
Can you please suggest query to get result.