KaskoazulNear Social Txs with methods LF example with problem
    Updated 2023-01-24
    WITH tx_with_method AS (
    SELECT
    ft.block_id
    , COALESCE(ft.block_timestamp, b.block_timestamp) AS block_timestamp
    , ft.tx_hash
    , SPLIT_PART(ft.action_id, '-', 2) AS action_no
    , ft.action_name
    , ft.method_name
    , ft.args
    , ft.deposit / POW(10,24) AS deposit_near
    , t.tx_signer as user_name
    , t.tx_receiver
    , PARSE_JSON(args) as message
    FROM
    near.core.fact_actions_events_function_call ft
    LEFT JOIN
    near.core.fact_blocks b
    ON
    ft.block_id = b.block_id
    LEFT JOIN
    near.core.fact_transactions t
    ON
    ft.tx_hash = t.tx_hash
    WHERE
    t.tx_receiver = 'social.near'
    AND t.tx_status = 'Success'
    AND ft.tx_hash IN ('GtbbaBMPaJjFejhLL81zcEppTgwGPJZkQL2p5TDbQLLY',
    '3pnLgfmy7EfC3PSCg2dojrJoWRTvAEraEkrHnhhpmGDj',
    'G1owSXJsKCAn7QRXvCDDi1YJ32HWGk4uxvUbQKZM31pn',
    '2JznHaQoziarWazXyuTnEbTXjJw82wur4QPaAjBZfoa4',
    'GFnir78NeZPPETonJjV8u5pizzNh9HJ62V3HsnA3zJZ2',
    'Am3sBhoFSKjD86kgaEpmcBUXyHM58gf6CNyCxg24NsCg',
    'EqRHjHmy512jrQKSqB9jzqdpvgZc5qUKbbfWmrkGuhnm',
    '3QHFegDRSHzL5G3mM9GriBPY7dSQm7gBG66Y7FM3MjoL',
    'BDCBUAmUSLroCRD7F1LAK1K3B53ZVGzZxELuBrMGDyQR'
    )
    Run a query to Download Data