How can I find alfresco empty foldres using Lucene Query

Question

I want to retrieve the list of folders in a specific node whose list of childrens is empty using Lucene query.

I create this query:

+PATH:"/app:company_home/cm:contexts/cm:ctx_exploitation/cm:runs/cm:Run_322645//."+Children is empty.

but it does not give good results.

What is the right Lucene syntax to do this

There's no way to do this with a single Lucene query. – Lista Feb 27 '19 at 17:20 — Lista, Feb 27 '19 at 17:20
CMIS is an option (supports JOINs). – Lista Feb 28 '19 at 10:04 — Lista, Feb 28 '19 at 10:04

score 2 · Accepted Answer · answered Feb 28 '19 at 06:02

There is no way to find empty folders using a Lucene query. However, there are some java services and javascript APIs in alfresco like 'FileFolderService' in Java and 'childByNamePath' in javascript, using them you can write your logic and find empty folders.

score 1 · Answer 2 · answered Feb 28 '19 at 15:36

1

You can find o bytes file using below lucene query.

TYPE:"cm:content" AND @cm:content.size:0

answered Feb 28 '19 at 15:36

Sanjay

2,481
1
13
28

the complete sentence could be something like the following, as @sanjay said :) PATH:"/app:company_home/cm:contexts/cm:ctx_exploitation/cm:runs/cm:Run_322645//*" AND TYPE:"cm:content" AND @cm\:content.size:0 – AHT Sep 16 '21 at 15:07

How can I find alfresco empty foldres using Lucene Query

2 Answers2

Linked