Give the 2 queries below - The first one works the second erros with
“code”: 2,
“codeName”: “BadValue”,
“name”: “MongoError”
I want to run and $or across 3 fields looking for a search term… (the 1st query is only to test if 3 condition on an $or work )
where={"$or":[{“objectId”:“UJsE5mPBE5”},{“title”:“Script writer”},{“dateGoLive”: “2021-11-11T11:00:00.813Z”} ]}
where={"$or":[{“objectId”:“UJsE5mPBE5”}, {“dateGoLive”: “2021-11-11T11:00:00.813Z”},{“title”:{"$text":{"$search":{"$term":“Job”}}}} ]}