Inspiring

Solved

To get no of documents created last month in the environment

9 replies
27 views

Hi,

I have a requirement where I need to get the total no of documents created last month in the environment.

I have added all the document folders in a constant and tried to fetch the documents count but I'm getting an error as "The passed parameter(s) are of the wrong type. Received the type List of Folder."

a!localVariables(
local!document: folder(
cons!DMF_DOCUMENT_FOLDERS_LIST,
"documentChildren"
),
sum(
a!forEach(
items: local!document,
expression: todate(document(fv!item, "dateCreated")) > today()-30,
)
)
)

Can anyone please help me.

harshitb6843Answer

Brainy

local!document: a!flatten(
  a!forEach(
    items: cons!DMF_DOCUMENT_FOLDERS_LIST,
    expression: folder(fv!item, "documentChildren")
  )
),

U

ujjwalr0002

Participating Frequently

Can you share the screenshot for the values which you have in your local variable actually this is working I tried using the same code it is working. Have you tested it?

P

pavitrad2763Author

Inspiring

Hi Ujjwal,

PFB screenshot with the values in the constant.

The code is working with individual folder. But I want for list of all the document folders in the environment.

U

ujjwalr0002

Participating Frequently

Ohhh I took it like you are storing folder in the constant.

harshitb6843

Brainy

The error is very specific. If it is not working with a list, you might have to iterate through that so you can pass an individual folder instead a list.

P

pavitrad2763Author

Inspiring

Hi Harshit,

Yeah, it worked when I passed individual folder but I want for list of all the document folders in the environment. Could you please help if we have any way other than this.

harshitb6843Answer

Brainy

local!document: a!flatten(
  a!forEach(
    items: cons!DMF_DOCUMENT_FOLDERS_LIST,
    expression: folder(fv!item, "documentChildren")
  )
),

Sign up

Login with SSO

Login to the community

Login with SSO