how does expression filters work

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

how does expression filters work

Postby WaitWaitW » Sun Jun 19, 2022 5:29 am

Hi !
I would like to make some reports using expression filters, but I don't see how it works, and I don't see any tutorial.
Could you tell me how it works ?
For example, I would like to begin with a report to see the strength of bet / bet / bet.
In SQL, it would be something like that :
SELECT
lookup_hand_groups.group_name,
count(*) * 100.00 /
(
select count(*) FROM
lookup_hand_groups,
lookup_hand_ranks,
tourney_hand_player_statistics
WHERE
id_action_f = 4 AND
id_action_T = 4 AND
id_action_r IN (4, 11, 14, 19, 36, 37, 49) AND
lookup_hand_groups.id_group = lookup_hand_ranks.id_group AND
tourney_hand_player_statistics.id_final_hand = lookup_hand_ranks.id_hand_rank
) as pct
FROM
lookup_hand_groups,
lookup_hand_ranks,
tourney_hand_player_statistics
WHERE
id_action_f = 4 AND
id_action_T = 4 AND
id_action_r IN (4, 11, 14, 19, 36, 37, 49) AND
lookup_hand_groups.id_group = lookup_hand_ranks.id_group AND
tourney_hand_player_statistics.id_final_hand = lookup_hand_ranks.id_hand_rank
GROUP BY
lookup_hand_groups.id_group
ORDER BY
lookup_hand_groups.id_group
;
I could do it in pgAdmin, but how can i do it in the report section of PT4 ?
Thanks.
WaitWaitW
 
Posts: 79
Joined: Fri Aug 03, 2012 4:21 am

Re: how does expression filters work

Postby Flag_Hippo » Sun Jun 19, 2022 1:46 pm

WaitWaitW wrote:I would like to make some reports using expression filters, but I don't see how it works, and I don't see any tutorial.
Could you tell me how it works ?

It's basically the same as custom statistics. For example if you want to filter based on the information in a particular column or test a custom statistic you can do that with expression filters as described here.
WaitWaitW wrote:For example, I would like to begin with a report to see the strength of bet / bet / bet.

I don't know anything about the SQL you have included here but if you want to see a report grouped by final hand strength then you can do that in PokerTracker 4 without using expression filters:

1. Create an 'All Players' report - Guide: Creating My Reports
2. Remove the 'Player' statistic.
3. Add the 'Final Hand' statistic.
4. Filter for a bet/bet/bet line in 'More Filters -> Hand Details -> Actions & Opportunities'. If you don't want hero hands included in the report then add a filter for NOT (Player Is Hero).
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: how does expression filters work

Postby WaitWaitW » Mon Jun 20, 2022 3:08 am

Thanks for the quick answer :)
WaitWaitW
 
Posts: 79
Joined: Fri Aug 03, 2012 4:21 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 15 guests

cron
highfalutin