MAX Formatter Returning NULL

Wappler Version : 3.4.0
Operating System : Windows 10
Server Model: NodeJS
DB: MySQL

Expected behavior

Using MAX should return the maximum value of the supplied column for the query on which this is being applied to.

Actual behavior

Returns null.

How to reproduce

image
I have a query which returns 1 or more row, with each having a column SortOrder.
I wish to get the MAX value. So I tried this:
{{queryOptions.max(SortOrder)}}
But this is returning null.

The MAX formatter is working fine on Client Side.

Community Page
Last updated: