KaskoazulNear Social Txs with methods LF example with problem
Updated 2023-01-24
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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