Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by 4StarGen » Mon Aug 31, 2015 8:37 am
Ty a lot
-
4StarGen
-
- Posts: 929
- Joined: Sat Mar 08, 2014 6:58 am
-
by epicteto » Thu Oct 29, 2015 7:22 am
Please, in a custom filter, what does the expression?
cc.id_gametype = 2
and?
cc.id_limit = 8
Thanks
-
epicteto
-
- Posts: 28
- Joined: Wed Jul 15, 2015 6:27 am
by kraada » Thu Oct 29, 2015 8:31 am
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.
-
kraada
- Moderator
-
- Posts: 54431
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by epicteto » Thu Oct 29, 2015 9:00 am
Thanks kraada
-
epicteto
-
- Posts: 28
- Joined: Wed Jul 15, 2015 6:27 am
by epicteto » Thu Oct 29, 2015 9:21 am
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))
-
epicteto
-
- Posts: 28
- Joined: Wed Jul 15, 2015 6:27 am
by denutza » Fri Aug 18, 2017 4:42 pm
BillGatesIII wrote:- 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
-
- Posts: 105
- Joined: Fri May 23, 2008 2:01 am
by denutza » Tue Sep 12, 2017 11:56 pm
denutza wrote:BillGatesIII wrote: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.
-
denutza
-
- Posts: 105
- Joined: Fri May 23, 2008 2:01 am
by BillGatesIII » Wed Sep 13, 2017 2:03 pm
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.
-
BillGatesIII
-
- Posts: 740
- Joined: Fri Dec 16, 2011 6:50 pm
by denutza » Thu Sep 14, 2017 5:07 am
BillGatesIII wrote: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.
-
denutza
-
- Posts: 105
- Joined: Fri May 23, 2008 2:01 am
by BillGatesIII » Thu Sep 14, 2017 11:41 am
You can use vs Hero stats for that.
-
BillGatesIII
-
- Posts: 740
- Joined: Fri Dec 16, 2011 6:50 pm
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: Google [Bot] and 42 guests