GET /datasets supports sorting of the output, but SQL dislikes order by on a JSON field value. The solution is to cast the field .as_string(), but this PR goes a step further to allow sorting based on converting a field value to int, float, bool, or date as well as the default str: for example, GET /datasets?sort=dataset.metalog.run.start_time:desc:date will produce a list of datasets sorted in descending order by the recorded collection start timestamp in the Pbench Agent metadata.log file. (This works even if some datasets lack a dataset.metalog.run.start_time file: SQL will return null values at the beginning of the list.)
PBENCH-1297
GET /datasetssupports sorting of the output, but SQL dislikesorder byon a JSON field value. The solution is to cast the field.as_string(), but this PR goes a step further to allow sorting based on converting a field value toint,float,bool, ordateas well as the defaultstr: for example,GET /datasets?sort=dataset.metalog.run.start_time:desc:datewill produce a list of datasets sorted in descending order by the recorded collection start timestamp in the Pbench Agentmetadata.logfile. (This works even if some datasets lack adataset.metalog.run.start_timefile: SQL will returnnullvalues at the beginning of the list.)