one more thing,
you could go deeper with
$params:=New object("queryPlan";True;"queryPath";True)
$esTable_1:=ds.Table_1.query("NOT (Field_2 IN :1)";New collection;$params)
which yields
{"Not":[{"item":"Constant Value: <Always NULL>"}]}
as opposed to
$params:=New object("queryPlan";True;"queryPath";True)
$esTable_1:=ds.Table_1.query("Field_2 IN :1";New collection;$params)
{"item":"Constant Value: <Always NULL>"}
---
the inverse of FALSE is TRUE, but the inverse of NULL is NULL.
it's counter-intuitive, but that how NULL works.
> On Mar 4, 2020, at 1:02, Tom Buckler <[email protected]> wrote:
>
> I think you are on to something, since
>
> (entityUUID IN [])
> NOT(entityUUID IN [])
> both return the same results.
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
