flipside

    near txn state test
    vetalnear txn state test
    Updated 2022-08-02
    SELECT
    tx:receipt[0].outcome.status as status,
    *
    from
    near.core.fact_transactions
    where
    (tx_hash='3yCdXvq8n2jxh2uyx4JnK7CEA4yxB82TqPtykERkApTu' -- failure
    OR
    tx_hash='DRakWjRW15BzENeuvFFPDGsgJrNoYpDaivPkYEUgRGFS') -- ok
    and CHARINDEX('Failure',status)=0
    --TX_SIGNER='mrptrading.near'

    --select *
    --from near.core.fact_receipts
    --where
    -- tx_hash='3yCdXvq8n2jxh2uyx4JnK7CEA4yxB82TqPtykERkApTu' -- failure
    -- OR
    --tx_hash='DRakWjRW15BzENeuvFFPDGsgJrNoYpDaivPkYEUgRGFS' -- ok
    Run a query to Download Data