Returning MaxValue

Classic Servoy
1

Hi All

I am new to Servoy. Having come from a non-programming background, I am making slow progress picking up scripting. For instance, I need to retrieve the Maximum value for a given column and put it in a different column in a new record. I tried to use the “getDataSetByQuery” function but could never seem to get it to work. In know this is probably very simple but any help would be greatly appreciated.

Thank You.

Tom Gill
Indiana

2

Welcome to Servoy!

Without getting “involved” with SQL you can just try with:

controller.sort('column_to_sort desc');
var record = foundset.getRecord(1);
foundset.newRecord(true,true);
column_to_assign = record.column_to_sort;

or

controller.sort('column_to_sort desc');
controller.setSelectedIndex(1);
var max_value = column_to_sort;
controller.newRecord();
column_to_assign = max_value;
3

Thanks for the info. I got it to do what I wanted it to do with the folling code:

[if ( workrecord_vehicle != ‘’ || workrecord_vehicle != null )
{
var maxReturnedRows = 10000;
var query = “select workrecord_end_miles from workrecord where workrecord_vehicle = '” + workrecord_vehicle + “'”
var dataset = databaseManager.getDataSetByQuery(controller.getServerName(), query, null, maxReturnedRows)

if ( dataset.getMaxRowIndex() > 0 )
{
foundset.sort(‘workrecord_end_miles desc’)
var record = foundset.getRecord(1)
workrecord_start_miles = record.workrecord_end_miles
controller.sort(‘workrecord_id asc’)
}
else
{
workrecord_start_miles = workrecord_to_vehicles.vehicle_startmileage
}
}]

Thanks Again.

This is fun.

Tom Gill
TAG Productions