PokerTracker

Code: Select all

tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, player p, tourney_blinds tb where thps.id_player = p.id_player and thps.id_blinds = tb.id_blinds and thps.position = 8 and (thps.amt_before / tb.amt_bb ) between 20 and 25)

Flag_Hippo wrote:If you want to filter based on the data of other players then you will need to build an expression filter that uses a subquery like this:

Code: Select all

tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, player p, tourney_blinds tb where thps.id_player = p.id_player and thps.id_blinds = tb.id_blinds and thps.position = 8 and (thps.amt_before / tb.amt_bb ) between 20 and 25)

This expression will filter hands where the BB had a stack between 20bb and 25bb and you can edit that accordingly for other positions and stack sizes. You can use this expression filter by clicking on the 'Filters' link and selecting 'Add New Expression Filters'. For more on how SELECT works see here.

hdegou wrote:is there a way to adjust this filter so instead of selecting one specific position, let’s say at least one stack between BB and CO has 20-25bb and doesn’t matter which one?

Code: Select all

tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, player p, tourney_blinds tb where thps.id_player = p.id_player and thps.id_blinds = tb.id_blinds and thps.position = 8 and (thps.amt_before / tb.amt_bb ) between 20 and 25) or tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, player p, tourney_blinds tb where thps.id_player = p.id_player and thps.id_blinds = tb.id_blinds and thps.position = 9 and (thps.amt_before / tb.amt_bb ) between 20 and 25) or tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, player p, tourney_blinds tb where thps.id_player = p.id_player and thps.id_blinds = tb.id_blinds and thps.position = 0 and (thps.amt_before / tb.amt_bb ) between 20 and 25) or tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, player p, tourney_blinds tb where thps.id_player = p.id_player and thps.id_blinds = tb.id_blinds and thps.position = 1 and (thps.amt_before / tb.amt_bb ) between 20 and 25)