topic Re: How to recursivly apply an automation chain to a document and to its children (and the children of its children and...) ? in Nuxeo Forum

How to recursivly apply an automation chain to a document and to its children (and the children of its children and...) ?

jour_ — Tue, 01 Apr 2014 17:30:27 GMT

Hi, I want to modify a property of a document and of all its descendants.

I have builded an automation chain ("myChain) to make it recursively. This chain is called by an user action.

It does work only for a document without child...

Here is the chain :

Fetch > Context Document(s)

Document > Update Property -value : myValue -xpath : mySchema:myProperty -saved : checked

Document > Get Children

Execution Context > Set Context Variable From Input -name : myList

Execution Flow > Run For Each -id : myChain -list : myList -isolate : checked -item : item

Can somebody help me ?

Re: How to recursivly apply an automation chain to a document and to its children (and the children of its children and...) ?

jour_ — Wed, 02 Apr 2014 10:06:27 GMT

Here is the error message I obtain

Re: How to recursivly apply an automation chain to a document and to its children (and the children of its children and...) ?

ThibArg_ — Sun, 06 Apr 2014 18:00:28 GMT

To get all the documents in a container (and sub-sub-sub-documents), you can use the Query operation to ftech all documents whose path starts with the path of the current folder:

Fetch > Query
    query: SELECT * FROM Document WHERE dcm:path STARTSWITH '@{Document.path}'
    language: NXQL

Then, you have a list of documents:

If you want to just update some fields, you can directly call Document > Update propertty or Document > Update Properties. The operation will be applyed for each document in the list
If you want to run a chain, use Execution Flow > Run Document Chain

So, your chain could be...

Fetch > Context Document
Document > Update Property
    value : myValue
    xpath : mySchema:myProperty
    saved : checked
Fetch > Query
    query: SELECT * FROM Document WHERE dcm:path STARTSWITH '@{Document.path}'
    language: NXQL
Document > Update Property
    value : myValue
    xpath : mySchema:myProperty
    saved : checked

... where all documents will have the "myValue" value in the mySchema:myProperty field.

Or you can use a subchain...

Fetch > Context Document
Document > Update Property
    value : myValue
    xpath : mySchema:myProperty
    saved : checked
Fetch > Query
    query: SELECT * FROM Document WHERE dcm:path STARTSWITH '@{Document.path}'
    language: NXQL
Execution Flow > Run Document Chain
    id: TheSubChain
    isolate: (depends on your needs)
    parameters: (none)

...with TheSubChain doing "something". Here, I am just logging an information:

Fetch > Context Document
Notification > Log
    level: warn
    message: Current doc is doc id @{Document.id}, path: @{Document.path}

IMPORTANT

The queryhere gets all and every Nuxeo document, which includes containers (Folder, typically), deleted (in the trash), hidden, etc. So, maybe you will want to tune the query. For example, to ignore Folder and usually hidden documents:

SELECT * FROM Document WHERE dcm:path STARTSWITH '@{Document.path}' AND ecm:mixinType != 'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted' AND ecm:primaryType != 'Folder'

Thibaud

Re: How to recursivly apply an automation chain to a document and to its children (and the children of its children and...) ?

jour_ — Tue, 08 Apr 2014 16:50:01 GMT

Thank you very much !