Search documents filtering on a property from a parent level

[dhaglund]

Lets say I have three document types. Project, SubProject and WorkFile. All of these data types have their own attributes. SubProjects reside only in Projects and they are both folders. WorkFile corrsponds to an actual file and can reside in either a Project, SubProject or normal Folder.

Now I want to find all WorkFiles of mime-type pdf that has a parent project where Project:Region = 'North'. How can I query something like this? Standard NXQL won't do it.

The first thing that comes to mind is making WorkFile inherit som meta-data from Project. This would lead to data duplication and I would need to code a listener or something to make sure attributes are inherited and kept in sync.

Would it be possible to build an Elastic index to solve this? Perhaps using a custom query provider? Or what would be the best way to solve this?

[dhaglund]

It turns out duplicating the data is the go-to rolution for this problem. But it is possible to write a custom ES writer to solve this also. The writer would be extended to stamp the parent info only in the ES version of the document. See nuxeo/modules/platform/nuxeo-elasticsearch/nuxeo-elasticsearch-core/src/main/java/org/nuxeo/elastics...