filter question?

[4StarGen]

Ty a lot

[epicteto]

Please, in a custom filter, what does the expression?

cc.id_gametype = 2

and?

cc.id_limit = 8

Thanks

[kraada]

id_gametype specifies what kind of game we are looking at, holdem or omaha. I believe 1 is holdem and 2 is omaha.

id_limit specifies the specific stake played at. This varies depending on your system as these values are populated by the order in which you import hands into your database.

[epicteto]

Thanks kraada

[epicteto]

To say that would be helpful to BillGatesIII or another who knows to explain to us how works the code in this thread:

cash_hand_player_statistics.id_hand in (
select chps.id_hand
from cash_hand_player_statistics as chps
where chps.flg_p_first_raise
and chps.flg_p_open_opp
and chps.position = 0
and chps.id_player in (
select
distinct on (pt.id_player) pt.id_player
from (
select
cc.id_player,
sum(cc.cnt_hands) over pl as cnt_hands,
sum(cc.cnt_p_rfi_btn) over pl as rfi_btn,
sum(cc.cnt_p_open_opp_btn) over pl as rfi_btn_opp
from cash_cache as cc
where cc.id_gametype = 2
and cc.id_limit = 8
and cc.cnt_players between 4 and 6
and to_char(now(), 'YYYYWW')::int - cc.date_played_year_week <= 26
window pl as (partition by cc.id_player)) as pt
where pt.cnt_hands >= 100
and pt.rfi_btn_opp > 0
and 100.0 * pt.rfi_btn / pt.rfi_btn_opp >= 70))

[denutza]

Code: Select all

cash_hand_player_statistics.id_hand in (
  select chps.id_hand
  from cash_hand_player_statistics as chps
  where chps.flg_p_first_raise
  and chps.flg_p_open_opp
  and chps.position = 0
  and chps.id_player in (
    select
      distinct on (pt.id_player) pt.id_player
    from (
      select
        cc.id_player,
        sum(cc.cnt_hands) over pl as cnt_hands,
        sum(cc.cnt_p_rfi_btn) over pl as rfi_btn,
        sum(cc.cnt_p_open_opp_btn) over pl as rfi_btn_opp
      from cash_cache as cc
      where cc.id_gametype = 2
      and cc.id_limit = 8
      and cc.cnt_players between 4 and 6
      and to_char(now(), 'YYYYWW')::int - cc.date_played_year_week <= 26
      window pl as (partition by cc.id_player)) as pt
    where pt.cnt_hands >= 100
    and pt.rfi_btn_opp > 0
    and 100.0 * pt.rfi_btn / pt.rfi_btn_opp >= 70))


Is anything in the latest version of PT4 causing this Filter Expression to return "Expression is NOT VALID!!" ?

[denutza]

Is anything in the latest version of PT4 causing this Filter Expression to return "Expression is NOT VALID!!" ?

My bad, it works in a Hand Report but just not the Player Reports.

[BillGatesIII]

If I understand you correctly, you don't need complex SQL in the Filter Expression. For example, if you want to filter for players with a VPIP greater than fifty you add '#VPIP# > 50'. To filter out other player types, first create the statistic, like 'BB Call vs SB Open' and put that in the expression.

[denutza]

If I understand you correctly, you don't need complex SQL in the Filter Expression. For example, if you want to filter for players with a VPIP greater than fifty you add '#VPIP# > 50'. To filter out other player types, first create the statistic, like 'BB Call vs SB Open' and put that in the expression.

Using that method, there to my knowledge is no way to specify: Opponent is in the specific position (BB if using BB Call vs SB Open), AND that hero is in the SB attempting a steal raise.

[BillGatesIII]

You can use vs Hero stats for that.