Searching for documents in a space with specific attributes

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.

jneeve

Does anyone know if its possible construct a lucene search that would let you search for documents that are only in spaces that have a specificy space property.

So, for example we have student spaces. The space has a 'school'  property.

Then, inside student space we have subfolders with document types. So say, type1, type2, type3, etc.

Can I construct a search that says 'find me all documents of 'type1' where its parent space has the matching property of 'School = 'Some School Name'

I was also wondering perhaps if it would be quicker to get all the possible list of spaces matching the first criteria , and then re-query the resultSet with the second set of criteria - I don't see a away (other than perhaps looping through the resultSet itself) to do this though.

Path type queries seem very slow though…  ideas? Thanks!

openpj

I'm sure that you can try to do this query in 2 steps:

Step 1
Find the right space (customPropertySpace="school"), in this way you'll get the nodeRef of the parent, with the following Lucene query:

@yourCustomPrefix\:yourCustomProperty:"school"‍

Step 2
Find all the content of the type1 as children of the previous nodeRef that you have found (parent), with the following Lucene query:

PARENT:"parentNodeRef.getId()" AND TYPE:"yourCustomPrefix:type1"‍

Hope this helps.