Regs Shoving Bvb Filter/Report

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Regs Shoving Bvb Filter/Report

Postby puyanwei » Sun May 02, 2010 7:58 am

Hey guys,

I wanna go through some hands that regs played, and see how loose or tight they shove bvb.

Can you think of a way of using the filter/making a report that can do this?

My criteria is like this;

PokerStars
$6.50 STTs
SB Shove Pre Flop [The Reg]
BB Calls [goes to Showdown]

I've tried using a filter but it only shows my bvb situations, and I wanna hands where they shove vs other players and compare them too.

Also, is there a way to filter out players who has less hands then a certain amount? This would be a useful to filter out the one time randoms..
puyanwei
 
Posts: 37
Joined: Wed Oct 21, 2009 8:25 am

Re: Regs Shoving Bvb Filter/Report

Postby kraada » Sun May 02, 2010 8:52 am

Go into the Holdem Tournament Hand section of the Reports tab, we'll be creating a new report there.

Add the following filters:
holdem_hand_player_statistics.position = 9
holdem_hand_player_statsistics.flg_steal_att
holdem_hand_player_statistics.flg_showdown
holdem_hand_player_statistics.enum_allin = 'P'

Uncheck "Filter on Active Player", add the Player stat, and whatever details you want about the hand. Run the report, sort by the Player stat, and then just don't look at the hands you're involved in. It will show you all hands where a player in the SB (position = 9) opened for a steal (flg_steal_att), went all in preflop (enum_allin = 'P') and reached showdown.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Regs Shoving Bvb Filter/Report

Postby puyanwei » Sun May 02, 2010 9:41 am

I've followed your instructions, but nothing seems to come up.

I've added stats; Player, Hand 1 and Hand 2 to the report.
puyanwei
 
Posts: 37
Joined: Wed Oct 21, 2009 8:25 am

Re: Regs Shoving Bvb Filter/Report

Postby kraada » Sun May 02, 2010 12:06 pm

Are you certain you unchecked "Filter on Active Player" and that you don't have any other filter set?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Regs Shoving Bvb Filter/Report

Postby puyanwei » Thu May 13, 2010 5:40 pm

Yea, followed instructions to the tee...

Nothing comes up...

I tried using a filter criteria too, chance to steal called/position 9/raise all in and hoped to see the hands in the tournament/hands tab but it just loads forever...
puyanwei
 
Posts: 37
Joined: Wed Oct 21, 2009 8:25 am

Re: Regs Shoving Bvb Filter/Report

Postby kraada » Thu May 13, 2010 6:19 pm

Hm, export the report and attach it to a support ticket and reference this thread and we'll look into what's going on here for you.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests