How to use orderBy for graphQL

Question

I am trying to sort reservesUSD of nested object dailyPoolSnapshots In descending order by timestamp and return it's first value (in other words, return the latest entry). I know almost nothing of GraphQL and it's documentation seems confusing and scarce. Can someone help me to figure out how to sort my objects?

I am using subgraphs on the Ethereum mainnet for Curve.fi to get information about pools

My code:

  pools(first: 1000) {
    name
    address
    coins
    coinDecimals
    dailyPoolSnapshots(first: 1, 
      orderBy:{field: timestamp, order: DESC}) {
      reservesUSD
      timestamp
    }
  }
}

It throws and error:

  "errors": [
    {
      "locations": [
        {
          "line": 0,
          "column": 0
        }
      ],
      "message": "Invalid value provided for argument `orderBy`: Object({\"direction\": Enum(\"DESC\"), \"field\": Enum(\"timestamp\")})"
    }
  ]
}```

score 1 · Answer 1 · answered Nov 18 '22 at 21:53

1

The orderBy and orderDirection are separate query params, and orderDirection needs to be lowercase for their enum syntax.

{
  platforms(first: 5) {
    id
    pools {
      id
      dailyPoolSnapshots(first: 1, orderBy: timestamp, orderDirection: asc) {
        timestamp
      }
    }
    poolAddresses
    latestPoolSnapshot
  }
  registries(first: 5) {
    id
  }
}

answered Nov 18 '22 at 21:53

Greg Brodzik

1,765
7
9

let the autocomplete / intelisense guide you – Greg Brodzik Nov 18 '22 at 21:55

score 1 · Accepted Answer · answered Nov 18 '22 at 21:54

Here is your solution

{
    pools(first: 1000) {
    name
    address
    coins
    coinDecimals
    dailyPoolSnapshots(first: 1, 
      orderBy: timestamp, orderDirection:desc) {
      reservesUSD
      timestamp
    }
  }
}

In the playground, you have the doc on the right, you can search dailyPoolSnapshots, if you click on it, you will have the documentation of this query

Sample for this query:

Type
[DailyPoolSnapshot!]!

Arguments
skip: Int = 0
first: Int = 100
orderBy: DailyPoolSnapshot_orderBy
orderDirection: OrderDirection
where: DailyPoolSnapshot_filter
block: Block_height

Arguments are all the params you can use

How to use orderBy for graphQL

2 Answers2