getBlockByHash_transactions view

Column Type Required

hash

String

Yes

transactionDetailsFlag

Boolean

Yes

difficulty

String

No

extraData

String

No

transactionsRoot

String

No

miner

String

No

nonce

String

No

sha3Uncles

String

No

gasLimit

String

No

size

String

No

timestamp

String

No

logsBloom

String

No

stateRoot

String

No

gasUsed

String

No

mixHash

String

No

number

String

No

parentHash

String

No

receiptsRoot

String

No

uncles

Array

No

transactionsBlockHash

String

No

transactionsChainId

String

No

transactionsBlockNumber

String

No

transactionsValue

String

No

transactionsType

String

No

transactionsFrom

String

No

transactionsGas

String

No

transactionsNonce

String

No

transactionsInput

String

No

transactionsGasPrice

String

No

transactionsHash

String

No

transactionsR

String

No

transactionsS

String

No

transactionsV

String

No

transactionsTo

String

No

transactionsTransactionIndex

String

No

Examples

SELECT count(*) FROM getBlockByHash_transactions WHERE hash = '0xb3b20624f8f0f86eb50dd04688409e5cea4bd02d700bf6e79e9384d47d6a5a35' AND transactionDetailsFlag = false