Get nodes without parent association informed

[nonets]

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:

[![enter image description here][1]][1]

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.

[![enter image description here][2]][2]

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

  [1]: https://i.stack.imgur.com/rUq2m.png
  [2]: https://i.stack.imgur.com/c0VxW.png

[sercama]

Hi None None‌

You can seach by node type using lucene or fts queries like TYPE:”ts:folderSet”. Howeven lucene and fts queries are not prepared to search by associations at the moment.

So, using Java API, you will have to search all nodes of type ts:folderSet, then you will have to iterate them and check if each node has not a source association of type ts:FolderSubSet.

Regards.

[nonets]

Is there a way to get them using pagination?

We're using 4.2.f version.

[nonets]

And what about NodeService (Alfresco 5.0.3 Public API)