prometheusDimensionX Mints
Updated 2023-09-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
⌄
/*SELECT
transaction_result:events[1]:value:fields[1] as minter,
transaction_result:events[1]:value:fields[0] as id, *
FROM flow.core.fact_transactions
WHERE proposer = '0xe3ad6030cbaff1c2'
AND transaction_result:events[0]:type = 'A.e3ad6030cbaff1c2.DimensionX.Mint'
AND transaction_result:events[1]:type = 'A.e3ad6030cbaff1c2.DimensionX.Deposit'
AND transaction_result:events[0]:value:fields[1] = '2' -- mint type 2
*/
SELECT block_timestamp, event_data, tx_id
FROM flow.core.fact_events
WHERE
event_contract = 'A.e3ad6030cbaff1c2.DimensionX'
AND tx_succeeded = true
--AND event_type='Mint'
--14719
Run a query to Download Data