Can I not use toUpper and toLower in RecordList filter?

#1

ManagerEmail=toLower(‘${user.email}’)

Above gives error:

image

I consider this a very common need and a serious limitation if it cannot be done.
Practical use of the above is to get all direct reports of the logged-on user.

#2

Hi,

You can try the “like” method:

'${user.email}' like ManagerEmail

https://docs.cortezaproject.org/corteza-docs/2023.9/integrator-guide/reporting/expr-reference.html#expr-str-comparison-like