Advanced Pack report filter + Custom Formula

[item]

Hi,

i have make some custom formula https://docs.espocrm.com/development...on-in-formula/ .
All custom formula work in entityManager->before...->Formula.

But i will use theses custom formula in Report ->Filter->Expression.. but i see only out-of-box formula.

There are no way for this or i am wrong ?

sample function : currentWeek, nextWeek

Thanks

[yuri]

Hi Item,

It does not work either?

[yuri]

Create custom/Espo/Custom/Resources/metadata/app/advancedReport.json

{
    "allowedFilterFormulaFunctionList": [
         "__APPEND__",
         "yourCustomFunction1",
         "yourCustomFunction2",
     ]
}

This should allow the functions but it won't make them to appear in autocompletetion.

[item]

Hi Yuri,
thanks but not allowed or unknow function.. but
out-of-box function :

currentWeek :

Expression w/ Operator :

WEEK_NUMBER_1: (date)

Equals

datetime\format(datetime\today(),,'W')

And for nextWeek :

datetime\format(datetime\addWeeks(datetime\today() , 1),,'W')

Thanks