> For the complete documentation index, see [llms.txt](https://daostack-1.gitbook.io/v1/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://daostack-1.gitbook.io/v1/guides/querying-the-subgraph.md).

# Querying the Subgraph

The full list of Subgraph Entities cached by DAOstack subgraph can be found [here](https://subgraph.daostack.io/). You can find all of the subgraph entities [here](<https://github.com/daostack/DAOstack-Hackers-Kit/blob/master/docs/stack/subgraph/entities.md >).

## 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*&#x20;

Details of all \`daos\` indexed by the DAOstack subgraph&#x20;

```
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*&#x20;

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
    }
  }
}
```

&#x20;Get all \`daos\` with more than 200 reputation holders

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

&#x20;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*&#x20;

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`.
* &#x20;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.&#x20;

Sort Reputation Holders by their reputation balance&#x20;

```
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*&#x20;

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**

&#x20;Get all DAOs except the first 5&#x20;

```
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
	}
}
```