The below table indicates fields will be available at each roll-up when making requests to listClearedOrders using the groupBy parameter.
listClearedOrders will 'hoist' data into higher rollup levels whenever the value is unambiguous, this can occur when,
- SIDE, RUNNER & MARKET level when only 1 bet is involved in the rollup - only 1 possible value for each field so they are all unambiguous (in particular, betId)
- RUNNER level when all bets are on the same side - value of side is unambiguous, priceRequested and priceMatched can be averaged, sizeSettled can be totalled.
- MARKET level when all bets are on the same selection/side combo - value of selectionId, handicap and side are unambiguous, priceRequested and priceMatched can be averaged, sizeSettled can be totalled.
- PersistenceType and OrderType are only displayed above BET level if all bets in the rollup have the same type
*=fields that may be hoisted (if lower level fields are unambiguous or the rollup contains only 1 bet)
Rollup level: | BET | SIDE | MARKET | EVENT | EVENT_TYPE | EXCHANGE |
|---|---|---|---|---|---|---|
Settled As | Y | Y | Y | Y | Y | Y |
| Settled Date | Y | MAX | MAX | MAX | MAX | MAX |
Bet Count | Y | Y | Y | Y | Y | Y |
| Profit | Y | SUM | SUM | SUM | SUM | SUM |
| Exchange Id | Y | Y | Y | Y | Y | Y |
| Event Type Id | Y | Y | Y | Y | Y | N |
| Event Id | Y | Y | Y | Y | N | N |
| Market Id | Y | Y | Y | N | N | N |
| Selection Id | Y | Y | N* | N | N | N |
| Handicap | Y | Y | N* | N | N | N |
| Side | Y | Y | N* | N | N | N |
| Price Requested | Y | AVG | N*(AVG) | N | N | N |
| Price Matched | Y | AVG | N*(AVG) | N | N | N |
| Size Settled | Y | SUM | N*(SUM) | N | N | N |
| Price Reduced | Y | Y | Y | N | N | N |
| Commission | N | N | Y | SUM | SUM | SUM |
| Bet Id | Y | N* | N* | N | N | N |
| Placed Date | Y | MAX | MAX | N | N | N |
| Persistence Type | Y | Y | Y | N | N | N |
| Order Type | Y | Y | Y | N | N | N |
| Regulator Code | Y | Y | Y | N | N | N |
| Regulator Auth Code | Y | Y | Y | N | N | N |
Voided Date(where applicable) | Y | MAX | MAX | N | N | N |
| BetOutcome | Y | N | N | N | N | N |