Nuxeo LTS2023 Automation Script and Retrieving Folder Properties

Sudarshan_Ghate

I have the following code Automation script code fragment.

 

var query = "SELECT * FROM Folder WHERE ecm:primaryType = 'Invoices';

var resultSet = Repository.ResultSetQuery(

      input, {

        query: query}

    );

 

Console.log("Processing Result Set");

    if (resultSet.length === 0) {

      Console.error("No matching Invoice Folder.");

    }

    else {

      var targetFolder = resultSet[0];

  

How do I enumerate the folder properties?  I am trying to find the Folder Path so that I can execute the Document.Move and move the incoming document into the folder.

Thank you,

SG

  

Josh-F-Hyland

I apologize, I meant to clarify this in the first reply. The Repository.ResultSetQuery operation returns arrays of values, not "documents". So each array entry is just a simple value. IMO you probably want to use Repository.Query operation, which will return an array of complete documents (so you can use result[i].path, result[i].title, result[i]["myschema:myfield"], etc.) If you wanted to use Repository.ResultSetQuery you need to list the properties that you want to fetch e.g. "SELECT ecm:path FROM Invoices" *or* fetch each document using the Repository.GetDocument operation.