PokerTracker

I'd like to code a stat that retrieves holecards if a player openshoves and got called, if the player openshoved but no one called I'd like to have a text displayed. For some reason the stat below only shows the instances where he got called

Code: Select all

string_agg(
    CASE
        WHEN cash_hand_player_statistics.amt_p_raise_made = cash_hand_player_statistics.amt_before
        and cash_hand_player_statistics.flg_p_first_raise THEN lookup_hole_cards.hole_cards
        WHEN lookup_hole_cards.hole_cards = NULL THEN 'no cards'
        ELSE NULL
    END,
    ','
)

Nevermind, I've figured it out