PokerTracker

Hi, I'm trying to create a filter that only shows me hands where I called a river bet with 2nd pair.

For the moment I created this (attached file), but the problem is that this filter shows me not only 2nd pair but also 3rd pair but i need a filter that shows me only 2nd pair and an other filter that shows me only 3rd pair.

It's possibile?

Very thx

I believe that "middle pair" is anything other than top or bottom pair, and as far as I'm aware there isn't a way to filter exactly 2nd pair.

had same issue
call riv bet just select
2 nd pr filter build w/ options
2 ways to have 2nd pr on river
flop 2nd pr= middle pr on flop- existing filter
add no over card on turn + river
not perfect but close 89 on a94 flop can be 4th pr on kq which are not overs to the ace hi flop
but mostly counterfeits smallisjh mid prs from flop

other way is flop top pr + have 1 over card on turn or river

WhiteRider wrote:I believe that "middle pair" is anything other than top or bottom pair, and as far as I'm aware there isn't a way to filter exactly 2nd pair.

Would it be possible to make an expression filter for specifically 2nd or 3rd pair hand values ?

cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.id_r_hand_strength = 2

I made the expression filter above for 2nd pair. However, when I apply it, it comes back with lower than 2nd pair as per the first and last line in the image.

As mentioned earlier in this thread there isn't a filter for exactly 2nd pair. cash_hand_player_combinations.id_r_hand_strength = 2 for one pair hands is middle pair (a pair higher than the lowest board card but not top pair) - see this post for all the id_x_hand_strength values.

For having 2nd pair on the river try this expression filter:

Code: Select all

cash_hand_player_combinations.flg_r_1pair
AND ((cash_hand_player_statistics.holecard_1 - 1) % 13) != ((cash_hand_player_statistics.holecard_2 - 1) % 13)
AND ((cash_hand_summary.card_1 - 1) % 13) != ((cash_hand_summary.card_2 - 1) % 13)
AND ((cash_hand_summary.card_1 - 1) % 13) != ((cash_hand_summary.card_3 - 1) % 13)
AND ((cash_hand_summary.card_1 - 1) % 13) != ((cash_hand_summary.card_4 - 1) % 13)
AND ((cash_hand_summary.card_1 - 1) % 13) != ((cash_hand_summary.card_5 - 1) % 13)
AND ((cash_hand_summary.card_2 - 1) % 13) != ((cash_hand_summary.card_3 - 1) % 13)
AND ((cash_hand_summary.card_2 - 1) % 13) != ((cash_hand_summary.card_4 - 1) % 13)
AND ((cash_hand_summary.card_2 - 1) % 13) != ((cash_hand_summary.card_5 - 1) % 13)
AND ((cash_hand_summary.card_3 - 1) % 13) != ((cash_hand_summary.card_4 - 1) % 13)
AND ((cash_hand_summary.card_3 - 1) % 13) != ((cash_hand_summary.card_5 - 1) % 13)
AND ((cash_hand_summary.card_4 - 1) % 13) != ((cash_hand_summary.card_5 - 1) % 13)
AND (
  (
    (((cash_hand_player_statistics.holecard_1 - 1) % 13) = ((cash_hand_summary.card_1 - 1) % 13)
     OR ((cash_hand_player_statistics.holecard_1 - 1) % 13) = ((cash_hand_summary.card_2 - 1) % 13)
     OR ((cash_hand_player_statistics.holecard_1 - 1) % 13) = ((cash_hand_summary.card_3 - 1) % 13)
     OR ((cash_hand_player_statistics.holecard_1 - 1) % 13) = ((cash_hand_summary.card_4 - 1) % 13)
     OR ((cash_hand_player_statistics.holecard_1 - 1) % 13) = ((cash_hand_summary.card_5 - 1) % 13))
    AND (
      CASE WHEN ((cash_hand_summary.card_1 - 1) % 13) > ((cash_hand_player_statistics.holecard_1 - 1) % 13) THEN 1 ELSE 0 END
      + CASE WHEN ((cash_hand_summary.card_2 - 1) % 13) > ((cash_hand_player_statistics.holecard_1 - 1) % 13) THEN 1 ELSE 0 END
      + CASE WHEN ((cash_hand_summary.card_3 - 1) % 13) > ((cash_hand_player_statistics.holecard_1 - 1) % 13) THEN 1 ELSE 0 END
      + CASE WHEN ((cash_hand_summary.card_4 - 1) % 13) > ((cash_hand_player_statistics.holecard_1 - 1) % 13) THEN 1 ELSE 0 END
      + CASE WHEN ((cash_hand_summary.card_5 - 1) % 13) > ((cash_hand_player_statistics.holecard_1 - 1) % 13) THEN 1 ELSE 0 END
    ) = 1
    AND ((cash_hand_player_statistics.holecard_2 - 1) % 13) != GREATEST(
      ((cash_hand_summary.card_1 - 1) % 13),
      ((cash_hand_summary.card_2 - 1) % 13),
      ((cash_hand_summary.card_3 - 1) % 13),
      ((cash_hand_summary.card_4 - 1) % 13),
      ((cash_hand_summary.card_5 - 1) % 13)
    )
    AND NOT (
      ((cash_hand_player_statistics.holecard_2 - 1) % 13) = ((cash_hand_summary.card_1 - 1) % 13)
      OR ((cash_hand_player_statistics.holecard_2 - 1) % 13) = ((cash_hand_summary.card_2 - 1) % 13)
      OR ((cash_hand_player_statistics.holecard_2 - 1) % 13) = ((cash_hand_summary.card_3 - 1) % 13)
      OR ((cash_hand_player_statistics.holecard_2 - 1) % 13) = ((cash_hand_summary.card_4 - 1) % 13)
      OR ((cash_hand_player_statistics.holecard_2 - 1) % 13) = ((cash_hand_summary.card_5 - 1) % 13)
    )
  )
  OR
  (
    (((cash_hand_player_statistics.holecard_2 - 1) % 13) = ((cash_hand_summary.card_1 - 1) % 13)
     OR ((cash_hand_player_statistics.holecard_2 - 1) % 13) = ((cash_hand_summary.card_2 - 1) % 13)
     OR ((cash_hand_player_statistics.holecard_2 - 1) % 13) = ((cash_hand_summary.card_3 - 1) % 13)
     OR ((cash_hand_player_statistics.holecard_2 - 1) % 13) = ((cash_hand_summary.card_4 - 1) % 13)
     OR ((cash_hand_player_statistics.holecard_2 - 1) % 13) = ((cash_hand_summary.card_5 - 1) % 13))
    AND (
      CASE WHEN ((cash_hand_summary.card_1 - 1) % 13) > ((cash_hand_player_statistics.holecard_2 - 1) % 13) THEN 1 ELSE 0 END
      + CASE WHEN ((cash_hand_summary.card_2 - 1) % 13) > ((cash_hand_player_statistics.holecard_2 - 1) % 13) THEN 1 ELSE 0 END
      + CASE WHEN ((cash_hand_summary.card_3 - 1) % 13) > ((cash_hand_player_statistics.holecard_2 - 1) % 13) THEN 1 ELSE 0 END
      + CASE WHEN ((cash_hand_summary.card_4 - 1) % 13) > ((cash_hand_player_statistics.holecard_2 - 1) % 13) THEN 1 ELSE 0 END
      + CASE WHEN ((cash_hand_summary.card_5 - 1) % 13) > ((cash_hand_player_statistics.holecard_2 - 1) % 13) THEN 1 ELSE 0 END
    ) = 1
    AND ((cash_hand_player_statistics.holecard_1 - 1) % 13) != GREATEST(
      ((cash_hand_summary.card_1 - 1) % 13),
      ((cash_hand_summary.card_2 - 1) % 13),
      ((cash_hand_summary.card_3 - 1) % 13),
      ((cash_hand_summary.card_4 - 1) % 13),
      ((cash_hand_summary.card_5 - 1) % 13)
    )
    AND NOT (
      ((cash_hand_player_statistics.holecard_1 - 1) % 13) = ((cash_hand_summary.card_1 - 1) % 13)
      OR ((cash_hand_player_statistics.holecard_1 - 1) % 13) = ((cash_hand_summary.card_2 - 1) % 13)
      OR ((cash_hand_player_statistics.holecard_1 - 1) % 13) = ((cash_hand_summary.card_3 - 1) % 13)
      OR ((cash_hand_player_statistics.holecard_1 - 1) % 13) = ((cash_hand_summary.card_4 - 1) % 13)
      OR ((cash_hand_player_statistics.holecard_1 - 1) % 13) = ((cash_hand_summary.card_5 - 1) % 13)
    )
  )
)

You can use this expression filter in 'My Reports' by clicking on the 'Filters' link and selecting 'Add New Expression Filters'.