Skip to content

ORM should support cross-schema selections

Domain table currently must be specified as table name only and we do not support specifying a schema with a prefix. This should be supported so domains can reference domains in other schemas as relations as required.

This should be possible to implement just by patching ORMHelper::getORMSelection() to explode(., table) (where table is the table name used as as an alias) and use the last exploded component as the alias (i.e. the actual table name); the issue is the schema prefix, when used, currently ends up within the alias when used as a column selection, resulting in an illegal alias equivalent to \schema`.`alias`(illegal.`). We do need to investigate further to ensure this implementation alone will sufficiently satisfy this issue without introducing its own issues.

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