Skip to content

Extern: CQL: Difference between "WHICH HAS Property price" and "WITH Property price"

https://gitlab.com/caosdb/caosdb-server/-/issues/192

Summary

Consider these queries:

COUNT Record WHICH HAS price -> Results: 19
COUNT Record WHICH HAS Property price -> Results: 19
COUNT Record WITH price -> Results: 19
COUNT Record WITH Property price -> Results: 0

This is far from intuitive!

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information