Howto check PFA?

[js2002]

How do I check "Player is not PFA and its a raised Pot (single and more)" --->"face_raise" should do the second part of the question I guess, but which is the common way to check for preflop aggressor?

I cant use p_raise = 0 (and call =1) because I could raise and the call preflop.

[js2002]

2. How do I check "Player is PFA"? sth like "last action was a raise"? Is this correct?

[WhiteRider]

To check for the player being the PFA you can use:
lookup_actions_p.action LIKE '%R'
(Their last preflop action was raise, as you suggested.)
Although now I write that I guess that would include hands where they raise all-in and someone else re-raises afterwards..

To check that the player is not the PFA in a raised pot you can check for:
holdem_hand_player_statistics.flg_p_face_raise AND NOT (lookup_actions_p.action LIKE '%R')
(you'll need to check that they saw the flop too, of course).

[js2002]

To check for the player being the PFA you can use:
lookup_actions_p.action LIKE '%R'
(Their last preflop action was raise, as you suggested.)
Although now I write that I guess that would include hands where they raise all-in and someone else re-raises afterwards..

To check that the player is not the PFA in a raised pot you can check for:
holdem_hand_player_statistics.flg_p_face_raise AND NOT (lookup_actions_p.action LIKE '%R')
(you'll need to check that they saw the flop too, of course).

Thx helps but I dont understand the part: "Although now I write that I guess that would include hands where they raise all-in and someone else re-raises afterwards.."

Please explain in simple english, thx

[WhiteRider]

A player's last action might be Raise, but if that puts them all in then another player could still raise behind them and become the PFA.
However, in that case the all-in player won't have any opportunities to act on the flop so I don't think it's a serious issue.

[js2002]

thx 4 info!

No its not really an issue because I ll check flop flags etc, soo it never changes my results....