Top offers component

[yangwao]

We would need component which would show NFTs with most offers.

Table columns should be sortable and be like

• Collection, Item, Total number of offers, Total amount of offers, Date of newest/last offer
• By default, sorted by the total amount of offers

For example this NFT,
https://beta.kodadot.xyz/bsx/gallery/1380208565-1
the single row would look like

| Spodee | Spoodee | 3 | 345 567 BSX | 1 day |

It can look like current offers at https://beta.kodadot.xyz/bsx/stats

• route could be /topoffers
• put links to /topoffers into dropdown from Stats in navbar

[zhengow]

I would like to use this query to filter nfts which has no offer:

query MyQuery {
  nftEntities(where: {offers_some: {}}) {
    offers {
      id
      createdAt
      updatedAt
      price
    }
    collection {
      name
    }
    name
  }
}

How do you think?

[kodabot]

ASSIGNED - @prachi00 🔒 LOCKED -> Thursday, July 28th 2022, 13:15:06 UTC -> 36 hours

[roiLeo]

I would like to use this query to filter nfts which has no offer:

query MyQuery {
  nftEntities(where: {offers_some: {}}) {
    offers {
      id
      createdAt
      updatedAt
      price
    }
    collection {
      name
    }
    name
  }
}

How do you think?

This query will be greedy without limit

[kodabot]

ASSIGNMENT EXPIRED - @prachi00 has been unassigned.

[zhengow]

I would like to use this query to filter nfts which has no offer:

query MyQuery {
  nftEntities(where: {offers_some: {}}) {
    offers {
      id
      createdAt
      updatedAt
      price
    }
    collection {
      name
    }
    name
  }
}

How do you think?

This query will be greedy without limit

So it is need to write a resolver right?

[yangwao]

Any progress on this @zhengow 👀

[zhengow]

Any progress on this @zhengow 👀

I'd like to wait until kodadot/snek#42 to be merged. 👀
Thus, I will know how to contribute to subsquid.

[vikiival]

This query will be greedy without limit

yup I would close this without limit :) kodadot/rubick#109

[zhengow]

kodadot/snek#45
Waiting for review.