preparac wrote:Or could I use also
AND NOT
(tourney_holdem_hand_player_statistics.enum_allin = 'P' AND tourney_holdem_hand_player_statistics.flg_p_open_opp AND lookup_actions_p.action LIKE 'R')
to exclude situations where a players first action is raising allin?
Please note that:
lookup_actions_p.action LIKE 'R'
..is equivalent to
lookup_actions_p.action = 'R'
If you want to incude times when the player made other actions after the initial raise you need to use this:
lookup_actions_p.action LIKE 'R%'
Please see the "Constructing Column Expressions" section of the Tutorial - Custom Reports and Statistics for more information on using LIKE and string comparisons.