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.
I use these filters, but I have several hands like this:
shortstacker have 10$ and I have 100$ he raise to 3, I 3bet to 10 (amount he has) and he calls. So we are allin pre, but this hand doesnt qualify for mentioned filters
Ah yes - you won't be able to filter for that situation at the moment I don't think. Please create a Support ticket about this, preferably with the hand history for an example hand, and I'll report it to the development team.
You could probably do this in a custom report, though. If you untick 'Filter on Active Player' in the report filters window and add a custom filter for:
holdem_hand_player_statistics.enum_allin = 'P'
..for all-in preflop, or:
holdem_hand_player_statistics.enum_allin != 'N' (for not 'none', so they were all in at any point)
Somewhat related to this, is there a HUD stat for 3Bet Preflop All-in%? Meaning out of the times they 3Bet, who many time do they shove AI. I think such a stat would be great to help differentiate fish who buy in small, from short stackers who's only game is to 3Bet shove AI. I looked through the stat list an I couldn't find something like this, perhaps I missed it though. The closest I found was 3 stats AI Flop, Turn, River.
There isn't a built-in stat for that but you could make a new version of the 3-bet stat and include a check for: holdem_hand_player_statistics.enum_allin = 'P'
It's well worth the effort of the initial learning curve - it really opens up the possibilities of PT3. If you get we're here to help - post what you've got so far and we'll help you out.