I've got a multi-tenancy site that includes some tables that use the Tree
behaviour. By multi-tenancy I mean that several different clients all store
their data in the same database and they can only access and manage their
own data.
For example, each client stores their departments in the
I solved this - it works but might be either brilliant or stupid.
I added a new field called path. In that field I store the full path from
the top level of the tree through all children to 'this' one - something
like this:
- Top Level Department Parent Department Child Department This