CQL: Spaces are not recognised in sub-property queries.

Consider the following case:

  • RecordType RTA and Record ReferencedRecord of that type
  • Two properties Wrapper and Wrapper with spaces which both are references to Records of type RTA
  • RecordType RTB with both wrapper properties
  • A record TestRecord which has ReferencedRecord as value of both wrapper properties

The Query SELECT Wrapper.name FROM RECORD RTA returns REferencedRecord as expected, while SELECT "Wrapper with spaces.name" FROM RECORD RTA returns an empty table (same for "Wrapper with spaces".name).

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