Gets one page of the trip-based Material Management data: in the Trip view, the trips in scope, with the material their vehicle spread during them. The rows are built from the live trips and the stored trip material aggregates, joined on vehicle and trip start, and follow the trip-based Material Management report, with these differences: a measure no activity contributed to is null where the report shows zero; the date range selects trips by their start, where the report selects them by their stop; each material type has its own total and rate, where the report shows the last type with the total and rate of them all; a rate's distance is the spread distance of the type's aggregate that reported a rate; and the plow measures are not recorded yet.
A trip has one row unless it has more than one type of a material. It then has as many rows as the material with the most types, and row n holds the n-th type, in ascending order of code, of every material that has one, so that every type has its own total and rate. The trip's own fields repeat in each of its rows.
Every trip in scope is returned, including trips with no spread activity, but never a soft-deleted trip or soft-deleted aggregate. Units are the report's storage units: solid in grams, anti-ice and pre-wet in litres, rates in kilograms per kilometre (solid), litres per kilometre (anti-ice) and litres per tonne (pre-wet), distances in kilometres and durations as time spans. See MaterialManagementTripBasedRecord. The default order is trip start, newest first, with a stable tie-break that keeps the rows of a trip together and in order. Sort by any column of the record by naming it in ISort.sortBy, for example solidTotal; null values sort lowest. Page with resultsLimit and resultsOffset, which count rows, and use WebMethods.GetMaterialManagementTripBasedCountAsync for the number of rows rather than recounting. The rows of one trip can fall on two pages.
Requires the Material Management report clearance and, as the trip-based report does, a clearance to view trips. Returns only the trips of the vehicles in the caller's groups, and only their own trips to a driver who may see only their own data. A driver outside the caller's driver groups shows as the Unassigned driver, as every driver does to a caller who cannot view users. The trip id changes when trips are merged, so the device id and trip start are the stable key of a trip.