In my application I routinely set the UUID of a foreign key for a new record to an inter-process variable <>vsNullUUID where
If I run this query on an entity selection it does not work if I include the search for the ID
$sel:=comp.DogsToCompany.query(“Gender = :1 and LitterID = :2”;“Male”;<>vsNullUUID)
If I omit LitterID search works and also work if I choose a different field.
In the debugger you can see the entities where the litterID is 00000000000000000000000000000000
Is this a valid query?