[listings] Expired (?) listings not showing on Profile page

[jabby09]

See this discord thread for further context,

logged in as https://www.carbonmark.com/users/jabby

No active listings??

In my Portfolio I have 3 assets that show Listed tonnes:

Another side note/issue is the Stats component says I have 4 Active listings??

@psparacino did a quick investigation and it looked like the listings were expired. However, an expired listing should not just disappear, they should have an EXPIRED label on them.

Related issues from initial implementation:

1525

1655

[jabby09]

From @psparacino Query for active listings with the timestamp of a month ago: [https://api.thegraph.com/subgraphs/id/QmaHkN47zUB3b1xnfeqCwatG5DRtMuitEDf9FdFkq5V3Fr/graphql?query=query+MyQuery(%24expiresAfter%3A+BigInt!)+%7B%0A++user(id%3A+"0x6476edf98Bdc5EE62f9D4E4BF8932d69Ed685483")+%7B%0A++++listings(where%3A+%7Bexpiration_gt%3A+%24expiresAfter%7D)+%7B%0A++++++updatedAt%0A++++++totalAmountToSell%0A++++++tokenSymbol%0A++++++tokenId%0A++++++tokenAddress%0A++++++singleUnitPrice%0A++++++minFillAmount%0A++++++leftToSell%0A++++++id%0A++++++expiration%0A++++++deleted%0A++++++createdAt%0A++++++batches%0A++++++batchPrices%0A++++++active%0A++++++project+%7B%0A++++++++vintage%0A++++++++updatedAt%0A++++++++registry%0A++++++++projectAddress%0A++++++++name%0A++++++++methodology%0A++++++++id%0A++++++++key%0A++++++%7D%0A++++%7D%0A++%7D%0A%7D](https://api.thegraph.com/subgraphs/id/QmaHkN47zUB3b1xnfeqCwatG5DRtMuitEDf9FdFkq5V3Fr/graphql?query=query+MyQuery(%24expiresAfter%3A+BigInt!)+%7B%0A++user(id%3A+%220x6476edf98Bdc5EE62f9D4E4BF8932d69Ed685483%22)+%7B%0A++++listings(where%3A+%7Bexpiration_gt%3A+%24expiresAfter%7D)+%7B%0A++++++updatedAt%0A++++++totalAmountToSell%0A++++++tokenSymbol%0A++++++tokenId%0A++++++tokenAddress%0A++++++singleUnitPrice%0A++++++minFillAmount%0A++++++leftToSell%0A++++++id%0A++++++expiration%0A++++++deleted%0A++++++createdAt%0A++++++batches%0A++++++batchPrices%0A++++++active%0A++++++project+%7B%0A++++++++vintage%0A++++++++updatedAt%0A++++++++registry%0A++++++++projectAddress%0A++++++++name%0A++++++++methodology%0A++++++++id%0A++++++++key%0A++++++%7D%0A++++%7D%0A++%7D%0A%7D)

same query except using today's timestamp: [https://api.thegraph.com/subgraphs/id/QmaHkN47zUB3b1xnfeqCwatG5DRtMuitEDf9FdFkq5V3Fr/graphql?query=query+MyQuery(%24expiresAfter%3A+BigInt!)+%7B%0A++user(id%3A+"0x6476edf98Bdc5EE62f9D4E4BF8932d69Ed685483")+%7B%0A++++listings(where%3A+%7Bexpiration_gt%3A+%24expiresAfter%7D)+%7B%0A++++++updatedAt%0A++++++totalAmountToSell%0A++++++tokenSymbol%0A++++++tokenId%0A++++++tokenAddress%0A++++++singleUnitPrice%0A++++++minFillAmount%0A++++++leftToSell%0A++++++id%0A++++++expiration%0A++++++deleted%0A++++++createdAt%0A++++++batches%0A++++++batchPrices%0A++++++active%0A++++++project+%7B%0A++++++++vintage%0A++++++++updatedAt%0A++++++++registry%0A++++++++projectAddress%0A++++++++name%0A++++++++methodology%0A++++++++id%0A++++++++key%0A++++++%7D%0A++++%7D%0A++%7D%0A%7D](https://api.thegraph.com/subgraphs/id/QmaHkN47zUB3b1xnfeqCwatG5DRtMuitEDf9FdFkq5V3Fr/graphql?query=query+MyQuery(%24expiresAfter%3A+BigInt!)+%7B%0A++user(id%3A+%220x6476edf98Bdc5EE62f9D4E4BF8932d69Ed685483%22)+%7B%0A++++listings(where%3A+%7Bexpiration_gt%3A+%24expiresAfter%7D)+%7B%0A++++++updatedAt%0A++++++totalAmountToSell%0A++++++tokenSymbol%0A++++++tokenId%0A++++++tokenAddress%0A++++++singleUnitPrice%0A++++++minFillAmount%0A++++++leftToSell%0A++++++id%0A++++++expiration%0A++++++deleted%0A++++++createdAt%0A++++++batches%0A++++++batchPrices%0A++++++active%0A++++++project+%7B%0A++++++++vintage%0A++++++++updatedAt%0A++++++++registry%0A++++++++projectAddress%0A++++++++name%0A++++++++methodology%0A++++++++id%0A++++++++key%0A++++++%7D%0A++++%7D%0A++%7D%0A%7D)

[jabby09]

From @biwano

[jabby09]

Approval records for the 3 listings form revoke.cash app