# Get all Pools by Owner

Pool details for a wallet can be fetched by applying a where filter on the <mark style="color:yellow;">owner</mark> field in Tensor's Pool Account.

{% hint style="success" %}
Account Joins can be seen in action here! We fetch pool data joined with the associated margin account.
{% endhint %}

Natively in RPC calls, if a wallet owns 100 pools you would need to fetch margin accounts for each one separately to get the balance. But here we are <mark style="color:yellow;">joining</mark> the pool data with the associated margin account, so you get everything in a single call.

\
You can directly copy paste this code on <mark style="color:yellow;">replit</mark> and see it in action.

{% tabs %}
{% tab title="Code Snippet" %}
{% code overflow="wrap" %}

```typescript
import { gql, GraphQLClient } from 'graphql-request';

const endpoint = `https://programs.shyft.to/v0/graphql?api_key=YOUR-API-KEY`; //Shyft's gQl endpoint

const graphQLClient = new GraphQLClient(endpoint, {
  method: `POST`,
  jsonSerializer: {
    parse: JSON.parse,
    stringify: JSON.stringify,
  },
}); //Initialize gQL Client

async function getAllPoolsByUser(walletAddr) {
    //you can select particular fields as per your requirement
    const query = gql`
    query MyQuery {
        Tensor_Pool(
          where: {owner: {_eq: ${JSON.stringify(walletAddr)}}}
        ) {
          frozen
          createdUnixSeconds
          Margin {
            owner
            poolsAttached
            lamports
          }
          nftAuthority
          nftsHeld
          orderType
          owner
        }
      }
    `;

  const response = await graphQLClient.request(query);
  console.dir(response,{depth: null});
}

getAllPoolsByUser('9XNuYM6ktSL4KcATv3seDBVhWAmVHEU42foY4t7skygg')
//replace this address to get all Pools of one particular owner
```

{% endcode %}
{% endtab %}

{% tab title="Response" %}

```json
{
  "data": {
    "Tensor_Pool": [
      {
        "frozen": null,
        "createdUnixSeconds": 1705505122,
        "Margin": {
          "owner": "9XNuYM6ktSL4KcATv3seDBVhWAmVHEU42foY4t7skygg",
          "poolsAttached": 4
        },
        "nftAuthority": "CVeiwtnGbGcFFEs71V7DQyvbBp5cv5uaGSkvibv3jAWP",
        "nftsHeld": 0,
        "orderType": 0,
        "owner": "9XNuYM6ktSL4KcATv3seDBVhWAmVHEU42foY4t7skygg"
      },
      {
        "frozen": null,
        "createdUnixSeconds": 1705505122,
        "Margin": {
          "owner": "9XNuYM6ktSL4KcATv3seDBVhWAmVHEU42foY4t7skygg",
          "poolsAttached": 4
        },
        "nftAuthority": "CVeiwtnGbGcFFEs71V7DQyvbBp5cv5uaGSkvibv3jAWP",
        "nftsHeld": 0,
        "orderType": 0,
        "owner": "9XNuYM6ktSL4KcATv3seDBVhWAmVHEU42foY4t7skygg"
      },
      {
        "frozen": null,
        "createdUnixSeconds": 1705505122,
        "Margin": {
          "owner": "9XNuYM6ktSL4KcATv3seDBVhWAmVHEU42foY4t7skygg",
          "poolsAttached": 4
        },
        "nftAuthority": "CVeiwtnGbGcFFEs71V7DQyvbBp5cv5uaGSkvibv3jAWP",
        "nftsHeld": 0,
        "orderType": 0,
        "owner": "9XNuYM6ktSL4KcATv3seDBVhWAmVHEU42foY4t7skygg"
      }
    ]
  }
}
```

{% endtab %}
{% endtabs %}