Player has position

[Biggetje]

For some reason I can't get the line: holdem_hand_player_detail.flg_f_has_position to work in my stats.

Here is my code:

Code: Select all

sum(if[cash_hand_player_statistics.position=8 AND
cash_hand_player_statistics.flg_p_first_raise AND
cash_hand_player_statistics.flg_p_4bet_opp, 1, 0])

So I'm in the BB, made the first raise and now have a chance to 4bet. This works, but I only want it in a BBvsSB situation.

I searched the forum and found a topic that suggested using: holdem_hand_player_detail.flg_f_has_position.

Now if I turn my code into:

Code: Select all

sum(if[cash_hand_player_statistics.position=8 AND
cash_hand_player_statistics.flg_p_first_raise AND
holdem_hand_player_detail.flg_f_has_position AND
cash_hand_player_statistics.flg_p_4bet_opp, 1, 0])

it says the statement is not valid SQL. Anyone knows what I'm doing wrong?

[4StarGen]

See my reply in your another post, IMO should be the same bug

[Biggetje]

Oh man, this is going to solve so many issues I had. Thanks and sorry for "polluting" the forums with what's essentially the same issue, I wasn't aware of this bug at all.

[4StarGen]

Happy to help man

[Biggetje]

<snip> mistake on my part.

In case someone else stumbles onto this: I made the mistake of using the wrong line:
holdem_hand_player_detail.flg_f_has_position
should be
cash_hand_player_statistics.flg_f_has_position