nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Extending CMIS query to get all documents with a property

kartech11

1I have an aspect that I have associated with multiple documents. For example lests call the aspect OrderAspect.

The below query works when I fetch all nodes that have a location property from OrderAspect set to 'WAREHOUSE-A'

SELECT * FROM oarderAspect WHERE oa:Location ='WAREHOUSE-A'

1. How can I extend this query to get all documents that have this aspect and the location value as 'WAREHOUSE-A'

2. Can I extend this query to search within a folder path or sit? I would like to list all the documents within a folder (including subfolder) or a site that has OrderAspect with property location set to 'WAREHOUSE-A'.

Find more posts tagged with

Alfresco Content Services

Comments

kartech11

Hi - Is there a way to do this? Would any expert be able to opine?

kranthi

try like this you will get all the documents associated with aspect orderAspect of location 'warehouse'

SELECT * FROM cmis:document AS d JOIN oarderAspect as p ON d.cmisbjectId = p.cmisbjectId WHERE oa:Location ='WAREHOUSE-A'