SandeshUntitled Query
Updated 2023-02-02Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with mem as
(
select
block_timestamp,
tx_hash,
RECEIVER_ID as dao,
ACTIONS:"predecessor_id" as voter,
parse_json(ACTIONS:"receipt":"Action":"actions")[0]:"FunctionCall":"method_name" as act,
parse_json(try_base64_decode_string(parse_json(ACTIONS:"receipt":"Action":"actions")[0]:"FunctionCall":"args")):"id" as proposal_id,
parse_json(try_base64_decode_string(parse_json(ACTIONS:"receipt":"Action":"actions")[0]:"FunctionCall":"args")):"action" as vote,
'-' as proposer
from near.core.fact_receipts
where 1=1
-- and tx_hash = 'JALXfYuPtsicggzBWiPUv8YqjY8SnncCvuZaZtA43SSP'
and RECEIVER_ID='marketing.sputnik-dao.near'
and act='act_proposal'
)
select * from mem
Run a query to Download Data