Hi Tom. I believe this statement has a silent syntax error, which the compiler/syntax checker fails to flag: $vC_uuidsToIgnore:=New collection()
Remove the parenthesis so you have: $vC_uuidsToIgnore:=New collection See: https://doc.4d.com/4Dv18/4D/18/New-collection.301-4505843.en.html <https://doc.4d.com/4Dv18/4D/18/New-collection.301-4505843.en.html> Best regards, Jeremy French > On Mar 1, 2020, at 2:05 PM, Tom-Lists via 4D_Tech <[email protected]> > wrote: > > Now assuming that the field "entityUUID" is populated (no null values), How > come I get different results with: > > $vC_uuidsToIgnore:=New collection() > $deletes:=ds.SyncDeletes.query("NOT(entityUUID IN :1)";$vC_uuidsToIgnore) > $deletes --> zero length entitySelection (not what I expect!) > > versus > $vC_uuidsToIgnore:=New collection("") > $deletes:=ds.SyncDeletes.query("NOT(entityUUID IN :1)";$vC_uuidsToIgnore) > $deletes --> all SyncDeletes records (good!) > > The ONLY difference between the above snippets is that one collection is > empty versus the other has a single empty value. > > v18.0 > > I can exclude uuids when my vC_uuidsToIgnore contains one or more UUID's, the > problem appears when that collection is empty… I should get ALL SyncDeletes > records. ********************************************************************** 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] **********************************************************************
