To get full access to the Kademi Hub existing customers can login here, or new customers can register here.
Table listing points debits reconciled against their originating credits, one row per participant, reward and points tag combination with the net points involved. Registered with the query engine as a Table so it can be looked up by id and read from reports and exports. Rows are summed from PointsDebitLink for the current tenant organisation over the currently selected date range.
Implements: Table
Properties
| Property | Returns | Description |
|---|---|---|
| description | String | Human readable description of what this table returns, shown to a report author when choosing a table. |
| headers | List<String> | Column header labels for this table: the reward name, participant name, points tag and net points. |
| tableId | String | Fixed id this table is registered and looked up under. |
Inherited from Table
Methods
getRows(int start, Integer maxRows)
Returns: RowsResult
Reads a page of rows starting at the given row, discarding any progress status. Delegates to the three argument overload with a status callback that does nothing.
| Parameter | Description |
|---|---|
start | the zero based index of the first row to return |
maxRows | the maximum number of rows to return, or null for no limit |
getRows(int start, Integer maxRows, Consumer<String> status, Map<String,Object> extraParams)
Returns: RowsResult
Reads a page of rows, optionally taking extra parameters that a specific table implementation can use to filter its results. The default implementation ignores extraParams and reads from row zero rather than the given start; implementations that use extraParams override this method directly.
| Parameter | Description |
|---|---|
start | the zero based index of the first row to return; not used by the default implementation |
maxRows | the maximum number of rows to return, or null for no limit |
status | callback invoked with progress messages while the rows are being read |
extraParams | implementation specific filter parameters; not used by the default implementation |
supportsPagination()
Returns: boolean
Whether this table supports paged reads via the start and maxRows parameters of getRows. A table that returns false always returns its full result set regardless of the paging parameters supplied.
Methods
getTableId()
Returns: String
Fixed id this table is registered and looked up under.
getDescription()
Returns: String
Human readable description of what this table returns, shown to a report author when choosing a table.
getHeaders()
Returns: List<String>
Column header labels for this table: the reward name, participant name, points tag and net points.
getRows(int start, Integer maxRows, Consumer<String> status)
Returns: RowsResult
Reads a page of points debits summed per participant, reward and points tag for the current tenant organisation, over the currently selected date range. When maxRows is null all matching rows are returned; otherwise the start and maxRows paging parameters are applied.
| Parameter | Description |
|---|---|
start | the zero based index of the first row to return |
maxRows | the maximum number of rows to return, or null for no limit |
status | not used by this table, present only to satisfy the Table interface |
© 2025 Kademi Ltd