topic Re: search for nodes without content in Alfresco Archive

search for nodes without content

darionis — Mon, 15 Jun 2015 20:24:22 GMT

Hello,I have a custom document model and I would like to find all custom documents that have no content. I tried with this query ASPECT:"nsp:customDoc" AND @cm\:created:[2015-06-15 TO 2015-06-15] AND ISUNSET:"cm:content"‍‍‍but it gives me "maxClauseCount is set to 10000" error. If I remove ISUNSET

Re: search for nodes without content

rjohnson — Mon, 15 Jun 2015 21:31:33 GMT

AND @cm:content.size:0

Re: search for nodes without content

darionis — Tue, 16 Jun 2015 07:53:40 GMT

Thnaks,
I did try @cm:content.size:0 but it returns nodes with 0 bytes content (like when you have a 0 byte file as a content) For example it finds comments that are blank. So content property has to be set in order to be found by this query.
I was hoping to find nodes that have no content at all?

Re: search for nodes without content

rjohnson — Tue, 16 Jun 2015 22:05:39 GMT

I have had a few documents created with no content (by accident actually) and they have no mimetype. You might try -@cm\:mimetype:* which in theory will return only documents that do not have the mimetype set. This would return 0 byte files as well, but again in theory -@cm\:content:* would return anything where cm:content is not set.

I haven't tried this but the theory goes that +@cm\:content:* would return anything where cm:content exists so -@cm\:content:* should return anything where cm:content does not exist.

Worth a go.

Re: search for nodes without content

darionis — Thu, 18 Jun 2015 07:27:59 GMT

Excellent! -@cm\:content.mimetype:* finds nodes without content. Combined with aspect clause, finds exactly what i wanted.

Many thanks!