Page 1 of 1

Filter Report EP vs BTN

PostPosted: Tue Sep 05, 2023 5:41 pm
by arnakk2424
Hello
I saw this post with google search
https://www.pokertracker.com/forums/vie ... 84#p345884
I try to figure it out for tournament
Hero is EP (4-7) and vilain is BTN single raised pot

Re: Filter Report EP vs BTN

PostPosted: Wed Sep 06, 2023 4:13 am
by Flag_Hippo
That would be:

Code: Select all
tourney_hand_summary.str_aggressors_p SIMILAR TO '84|85|86|87' and tourney_hand_summary.str_actors_p SIMILAR TO '40|50|60|70'

For more information on pattern matching in PostgreSQL see this guide.

Re: Filter Report EP vs BTN

PostPosted: Wed Sep 06, 2023 11:06 am
by arnakk2424
Flag_Hippo wrote:That would be:

Code: Select all
tourney_hand_summary.str_aggressors_p SIMILAR TO '84|85|86|87' and tourney_hand_summary.str_actors_p SIMILAR TO '40|50|60|70'

For more information on pattern matching in PostgreSQL see this guide.


wow I would never been close to that
what should I add to see only the hands hero is 4-7. the filter below is anyone in the specific scenario

Re: Filter Report EP vs BTN

PostPosted: Thu Sep 07, 2023 5:00 am
by Flag_Hippo
Add a built-in filter for being the first raiser or add tourney_hand_player_statistics.flg_p_first_raise to the expression filter.