nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

How to compute a metadata on a document according to a metadata of its children with automation ?

Christophe_

I have a metadata called "total" on a document. This document can have a variable number of children documents, all having a metadata called "amount".

How can I parameter an automation chain to calculate the "total" from the parent document which must be equal to the sum of the "amount" of its children documents ?

Thanks for your help !

Find more posts tagged with

Comments

Bing_Ren

It seems to me the best bet is to implement somekind of event handler, listening change event on child document. Then child document get its parent to recalculate the total.

Christophe_

Thanks for your reply

sdenef_

not the solution, but it can helps :

I did a groovy script for Nuxeo Shell, similar to your needs Hope it can inspire you

import org.nuxeo.ecm.core.api.IdRef;
import org.nuxeo.ecm.core.api.PathRef;

def ref = Context["ref"];
def docRoot = null;

if (ref == null || ref == "") { return "Context execution variable not set : ref"; }

try {   
  if (ref.startsWith("/")) {
    docRoot = Session.getDocument(new PathRef(ref));
  } else {
    docRoot = Session.getDocument(new IdRef(ref));
  }
} catch (Exception e) {
  return "Exception: ${e.getMessage()}.";
}

def docRootAndChildren = [];
docRootAndChildren = Session.query("SELECT * FROM Folder WHERE ecm:path STARTSWITH '${docRoot.getPath()}'");

def total = 0;
for (doc in docRootAndChildren) {
  total += Integer.parseInt(doc.getProperty("dublincore", "source"));
}

return  "total = ${total}";

Bing_Ren

I can think of mainly three ways to do this, but none I know exactly how to implement, because I myself is very green in Nuxeo development and am trying to figure out how to do simple things.