Alfresco: Search all nodes without parents

Question

I'd like to know how to get all nodes of a given type ts:folderSet which has no parent association of type ts:FolderSubSet informed.

Currently:

So, I mean, I need all nodes of type ts:folderSet where tsfss:folderSubSet-folder is null or not informed.

Currently, I'm using admin tool in order to build this query, but I'll need to use it into a java code.

So I mean, I can use FTS or lucene... Any ideas?

Possible duplicate of [How can I find alfresco empty foldres using Lucene Query](https://stackoverflow.com/questions/54902243/how-can-i-find-alfresco-empty-foldres-using-lucene-query) — Lista, Mar 08 '19 at 12:41

score 0 · Answer 1 · answered Mar 29 '19 at 17:24

0

If your parent type is different you can do: +TYPE:"ts:folderSet"

answered Mar 29 '19 at 17:24

Rbkpro Dev

31
1

score 0 · Answer 2 · answered Apr 15 '19 at 17:01

The problem is that the PARENT keyword in search uses the primary parent. Your ts:folderSubSet object is a secondary parent to your ts:folderSet object. I don't think you will be able to write a single query that can find instances of ts:folderSet that do not have an instance of ts:folderSubSet as a secondary parent.

You can write a query that returns ts:folderSet objects and then you can iterate over each one of the results checking its list of parents for the secondary object. Not ideal, but it is probably the best you can do.

Kintu Barot · Answer 3 · 2019-03-08T12:12:53.607

-1

You can search for a type of nodes using the following Lucene query

TYPE:"cm:folder"

edited Mar 08 '19 at 12:12

answered Mar 08 '19 at 12:07

Kintu Barot

320
2
11

Yes, but what about this node has no parent? – user10063942 Mar 08 '19 at 12:13
Any node in alfresco will be of a specific type. It may be a folder, a document or it can be a user. You can search any node by its type. – Kintu Barot Mar 11 '19 at 05:35

Alfresco: Search all nodes without parents

3 Answers3