transactions for a block should be listed in the order that they exist in the block #63

Open
opened 2019-05-29 23:39:11 +02:00 by BrannonKing · 2 comments
BrannonKing commented 2019-05-29 23:39:11 +02:00 (Migrated from github.com)
"d33b00cb796d3fd510470a2dff741a5534c457d6e9468fc57dd122cbaeb2351c",
"02c8ede0b6c950a2067ab31fbfe162bf9614712fe673bd15ad4e55bbe54afbbb",
"98e93843c1d442e276761b387c260d0e620011b823f32b65eb28073c7a1fccf7",
"b8d2725b2f8e65de95a78114e6ac1dc728208a5989d1e5d65761197798bc2ca2"

vs
image (1)

``` "d33b00cb796d3fd510470a2dff741a5534c457d6e9468fc57dd122cbaeb2351c", "02c8ede0b6c950a2067ab31fbfe162bf9614712fe673bd15ad4e55bbe54afbbb", "98e93843c1d442e276761b387c260d0e620011b823f32b65eb28073c7a1fccf7", "b8d2725b2f8e65de95a78114e6ac1dc728208a5989d1e5d65761197798bc2ca2" ``` vs ![image (1)](https://user-images.githubusercontent.com/1509322/58593343-e0e5c200-8227-11e9-80f6-9d0dc6031e52.png)
tiger5226 commented 2019-05-30 02:51:59 +02:00 (Migrated from github.com)

we will have to add a sequence number column in chainquery. Currently we don't store this value for a transaction so there is no way for explorer to sort them properly. Will create/link issue.

we will have to add a sequence number column in chainquery. Currently we don't store this value for a transaction so there is no way for explorer to sort them properly. Will create/link issue.
marcdeb1 commented 2021-01-08 11:03:22 +01:00 (Migrated from github.com)
I don't see a column indicating sequence number in Chainquery. [https://chainquery.lbry.io/api/sql?query=SELECT%20*%20from%20transaction%20WHERE%20block_hash_id=%225faccc32a3fd3b9fb62589df94775cd8f2fb5b0fc5207820f6986ae84a16db72%22%20LIMIT%2010](https://chainquery.lbry.io/api/sql?query=SELECT%20*%20from%20transaction%20WHERE%20block_hash_id=%225faccc32a3fd3b9fb62589df94775cd8f2fb5b0fc5207820f6986ae84a16db72%22%20LIMIT%2010) Is there an issue to add it ?
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: LBRYCommunity/block-explorer#63
No description provided.