Search documents filtering on a property from a parent level

dhaglund — Wed, 24 Sep 2025 11:50:44 GMT

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?

Re: Search documents filtering on a property from a parent level

dhaglund — Wed, 01 Oct 2025 10:46:18 GMT

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/elasticsearch/io/JsonESDocumentWriter.java at 2023 · nuxeo/nuxeo

topic Re: Search documents filtering on a property from a parent level in Nuxeo Forum

Search documents filtering on a property from a parent level

Re: Search documents filtering on a property from a parent level