Offset pagination and total count?

#hasura #graphql

Overview

I am playing with Hasura / grapghql and having an issue with offset pagination to include total number of records in certain structure.

Query

Below is an example query I am doing to get the second page with 3 items.

query getItems {
  items(offset: 2, limit: 3) {
    id
  }
  items_aggregate {
    aggregate {
      count
    }
  }
}

Query Results

You can see that to get the total number of records the property is item_aggregated.aggregate.count. That is a bit messy and long just for a total count.

{
  "data": {
    "items": [
      {
        "id": "829b1baa-344d-4360-8d11-eb31fa592f29"
      },
      {
        "id": "0ac64c11-1e40-44c3-84ad-4eb5e2e495a9"
      },
      {
        "id": "827fcfa8-6ce6-4612-9bab-3ea62969f041"
      }
    ],
    "items_aggregate": {
      "aggregate": {
        "count": 100
      }
    }
  }
}

Required Results

Below is the result structure I would like to get back. You can see that items now have 2 different properties:

records array of the actual data
total an integer for the total record count.

{
  "data": {
    "items": {
       "records":[
            {
              "id": "829b1baa-344d-4360-8d11-eb31fa592f29"
            },
            {
              "id": "0ac64c11-1e40-44c3-84ad-4eb5e2e495a9"
            },
            {
              "id": "827fcfa8-6ce6-4612-9bab-3ea62969f041"
            }
          ],
       "total":100
    }
  }
}

Question

To my understanding this can be done by using a resolver or a custom function but not sure how you do this. If someone can provide me sample on how to do this?