Restrictions on operators

The Logical OR (||) operator cannot be used between different properties.

The logical AND (&&) operator cannot be used inside an OR expression as incorrect query results will be returned.

For example, the query: where h.ID == key || h.ID == key2 && h.Description3 == uuid2* will be interpreted as the query where (h.ID == key || h.ID == key2) && h.Description3 == uuid2 as the Scanjour Object Model (SOM) does not support the first query.

 

* i.e. where h.ID == key || (h.ID == key2 && h.Description3 == uuid2))