Querying the Subgraph

The full list of Subgraph Entities cached by DAOstack subgraph can be found here. You can find all of the subgraph entities here.

Query for single Entity

When you query for single Entity with all/some fields, you need to provide the Entity id.

Details of Genesis DAO 0x294f999356ed03347c7a23bcbcf8d33fa41dc830

query {
  dao (id: "0x294f999356ed03347c7a23bcbcf8d33fa41dc830") {
    name
    numberOfQueuedProposals
    numberOfBoostedProposals
    numberOfPreBoostedProposals
    proposals{
      title
    }
    reputationHoldersCount
  }
}

Details of Proposal 0x0025c38d987acba1f1d446d3690384327ebe06d15f1fa4171a4dc3467f8bd416

query {
  proposal (id: "0x0025c38d987acba1f1d446d3690384327ebe06d15f1fa4171a4dc3467f8bd416") {
    proposer
    createdAt
    expiresInQueueAt
    title
    votesFor
    votesAgainst
    dao {
      id
      name
    }
  }
}

Query for Multiple Entities

Query all

Just change the entity name to plural to query for all the entities of that type

Examples

Details of all `daos` indexed by the DAOstack subgraph

query {
  daos{
    name
    id
    reputationHoldersCount
    proposals{
      id
      title
    }
  }
}

Details of all `Reputation Holders` in DAOstack DAOs

query {
  reputationHolders {
    id
    address
    balance
    dao{
      name
    }
  }
}

Filter by fields

To query for a subset of Entities you can add where: {} parameter to filter for different properties. You can filter for single or multiple properties.

Filter top level entity

Examples

To get all proposals submitted on 2019 Halloween, we can filter for the time interval on `createdAt` property

query {
  proposals (
    where : {
      createdAt_gt: 1572480000,
      createdAt_lt: 1572566400
    }
  ) {
    id
  	title
    dao {
      name
    }
  }
}

Get all `daos` with more than 200 reputation holders

query {
  daos (
    where: {
      reputationHoldersCount_gt: 200
  }) {
    name
    reputationHoldersCount
  }
}

Genesis DAO proposals that contains word 'Reputation' in title

query {
  proposals (
    where: {
      dao: "0x294f999356ed03347c7a23bcbcf8d33fa41dc830"
      title_contains: "Reputation"
    }
  ){
    title
    dao{
      name
    }
  }
}

Filter complex subfield array

Examples

Get rewards detail for all DAO where 250 GEN or more were awarded in DAO bounty

query { 
  daos {
    name
		rewards (
      where: {
        daoBountyForStaker_gte: "250000000000000000000"
      }
    ){
      proposal {
        id
      }
      daoBountyForStaker
    }
  }
}

NOTE:

  • The suffix _contains in the above example is used for the comparison

  • Some suffixes are only supported for specific types. For example, Boolean only supports _not, _in, and _not_in.

  • Complete list of suffix is _not _gt _lt _gte _lte _in _not_in _contains _not_contains _starts_with _ends_with _not_starts_with _not_ends_with

Sort by field values

Sort top level entity

Examples

To query for a sorted list you can add orderBy parameter to sort by a specific property. Also, you can specify the direction of sort asc for ascending and desc for descending.

Sort Reputation Holders by their reputation balance

query {
  reputationHolders(
    orderBy: balance,
    orderDirection: desc
  ){
    address
    balance
  }
}

Sort DAOs by number of boosted proposals it has

query {
  daos (
    orderBy: numberOfBoostedProposals,
    orderDirection: asc
  ) {
    name
    numberOfBoostedProposals
  }
}

Sort complex subfield array

Examples

Get all proposals from all the daos ordered by the date of submission

query { 
  daos {
  	proposals (
      orderBy: createdAt,
      orderDirection: desc
    ){
      title
    }
  }
}

Paginate

You can also decrease the size of set queried by specifying the pagination limit

Examples

From the beginning

Get first 3 DAOs based on highest number of reputation holders

query{
  daos (
    first: 3
    orderBy: reputationHoldersCount
    orderDirection: desc
  ) {
    name
    numberOfBoostedProposals
  }
}

From the middle

Get all DAOs except the first 5

query{
  daos (
    skip: 5
    orderBy: reputationHoldersCount
    orderDirection: desc
  ) {
    name
    numberOfBoostedProposals
  }
}

Get the next 3 DAOs after the top 3

query {
  daos (
    skip: 3
    first: 3
    orderBy: reputationHoldersCount
    orderDirection: desc
  ) {

    You
  	name
 		reputationHoldersCount
	}
}

Last updated