MAX Formatter Returning NULL

Wappler General Bugs
,
#1

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.

#2
#3

Did you use the UI for the max formatter?

Expression should be {{queryOptions.max("SortOrder")}}

#4

Yes.

This worked. Thanks. :slight_smile:

#5

So the UI generated it incorrectly without the quotes?

Then @George should perhaps have a look at it.

#6
#7