Data Tables and MIN/MAX values

PeterJ · September 8, 2018, 1:37pm

Is using a Python list comprehension the only way to compute a MIN/MAX value of a column in a Data Table? Or is there a (undocumented?) “native” way to do this with the .search() method?

stefano.menci · September 8, 2018, 2:37pm

What about this?

max_value = app_table.my_table.search(tables.order_by("my_column", ascending=False))[0]['my_column']
min_value = app_table.my_table.search(tables.order_by("my_column", ascending=True))[0]['my_column']

PeterJ · September 8, 2018, 4:06pm

Stefano, that’ll do! Can’t believe I didn’t try it that way!