Page 1 of 3

How to filter Final Tables and ITM MTTs

PostPosted: Mon Nov 12, 2012 3:04 pm
by CyberSam
How do I filter ITM and Final Tables from MTTs?

Re: How to filter Final Tables and ITM MTTs

PostPosted: Mon Nov 12, 2012 3:52 pm
by kraada
There isn't a built in filter for this, but you can filter for it in the My Reports page by using the blue filters link and the following Filter Expression:

tourney_hand_player_statistics.id_tourney in (SELECT tr.id_tourney from tourney_results tr, tourney_hand_player_statistics thps, tourney_summary ts where tr.id_player = thps.id_player and tr.id_tourney = ts.id_torurney and thps.flg_hero and tr.amt_won > ts.amt_buyin + ts.amt_fee + (tr.cnt_rebuy * ts.amt_rebuy) + (tr.cnt_addon * ts.amt_addon))

Re: How to filter Final Tables and ITM MTTs

PostPosted: Mon Nov 12, 2012 5:38 pm
by CyberSam
I tried that, but got an error:
"Expression is NOT valid!"

I'm trying to find a way to filter out and replay all FT tournaments - what's the best way to do this?
Note that I have many 8-), so I really need some filtering to find them easier, especially the FT hands for ICM.

Re: How to filter Final Tables and ITM MTTs

PostPosted: Mon Nov 12, 2012 6:05 pm
by CyberSam
..and not only that - I just found out that I don't even know how to make PT4 recognize FTs:
when I'm trying to click that green little ICM button on Final Table hands - it gives me the same old error
about supporting only 2-10 player tournaments.

*sigh*

Re: How to filter Final Tables and ITM MTTs

PostPosted: Mon Nov 12, 2012 6:27 pm
by kraada
If you just want final tables you could use a much simpler filter - the ITM part is what is complicated.

For final tables you could filter on MTT and then add this filter expression:

tourney_results.val_finish between 1 and 9

Re: How to filter Final Tables and ITM MTTs

PostPosted: Mon Nov 12, 2012 6:48 pm
by CyberSam
Thanks - that seems to be working.

Then, how do I make PT4 understand FTs for correct ICM, without manual input (that can't be saved even) through FT ICM Calc for every hand separately?
I only get those errors about "2-10 players only" from all FT hands.

Re: How to filter Final Tables and ITM MTTs

PostPosted: Mon Nov 12, 2012 7:08 pm
by kraada
We need to know the exact payout structure in order for ICM to work properly - without it we can't assign the proper values to the chips.

If you could attach an example tournament with the payout structure in a support ticket we'll look into getting these working properly for you.

Re: How to filter Final Tables and ITM MTTs

PostPosted: Mon Nov 12, 2012 7:48 pm
by CyberSam
Wouldn't that work for one specific type of MTT only, with set number of players?

I'm playing on diff. networks, diff. type of MTTs, 25-45 MTTs a day (when I play),
so I'd need to set up tenths of payout structures - based on MTT types on diff. networks and diff. number of players on them :roll:

So I'm looking to see PT4 recognize payout structures from tournament histories (haven't tried with PokerStars files yet, but it doesn't?),
OR be able to save "custom" templates for payout structures, from manual inputs: I see there's few structures punched into PT4 and I can
use "custom" for the rest - but I can't save them for later use.

Re: How to filter Final Tables and ITM MTTs

PostPosted: Tue Nov 13, 2012 9:30 am
by kraada
If we have the payout information for all opponents that should be sufficient, and I'm pretty sure the PokerStars payout structures are known and in our tournament detection. The structures listed on the ICM calculator are the most common, but you're right that they don't save.

Re: How to filter Final Tables and ITM MTTs

PostPosted: Tue May 31, 2016 4:56 am
by sasieightynine
I'm using this for filtering out FT hands in reports. " NOT ((tourney_results.val_finish > 9) OR ((tourney_results.val_finish between 7 AND 9) AND (tourney_hand_player_statistics.cnt_players < 7))) " This filters out every hand when hero finishing 10th+ and also when hero is finishing between 7th and 9th but have not knocked out on the final table.