SandeshUntitled Query
    Updated 2023-02-02
    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