getTransactionByBlockHashAndIndex view

Column Type Required

blockHash

String

Yes

transactionIndexPosition

String

Yes

r

String

No

hash

String

No

v

String

No

blockNumber

String

No

chainId

String

No

type

String

No

from

String

No

input

String

No

nonce

String

No

gas

String

No

gasPrice

String

No

transactionIndex

String

No

s

String

No

to

String

No

value

String

No

Examples

SELECT * FROM getTransactionByBlockHashAndIndex WHERE blockHash = '0xb3b20624f8f0f86eb50dd04688409e5cea4bd02d700bf6e79e9384d47d6a5a35' AND transactionIndexPosition = '0x0'