Folding best hand OTR

[stolkachov]

Hi,
is it possible to create a filter based on equity?
Like I'd like to filter hands where I had 100% equity OTR and folded to a bet (basically when I got bluffed).

Thanks.

[Flag_Hippo]

Equity is only calculated and stored in the database at the point of an all-in so that cannot be filtered for directly. Furthermore your opponents hand wouldn't be known unless this is on Ignition and in that case something might be possible with a subquery that compares the winning hand to your own - for more on how SELECT works see here.

[stolkachov]

Yes, obviously I was talking about Ignition all other times you just won't know opps hand. Sorry for not clearing this up.
Can you give me a little hint where to look for it in the db please?

[stolkachov]

Another question. So when I see equities in replayer it is just calculated in real time right?
So there is no way to access that.

Because essentially what I would like is to see hands where it shows 100% for Hero in replayer OTR and I fold.
Can be killer feature if you think about it.

[WhiteRider]

For information on the made hand strength database fields see this thread.

If you want to look at the hole cards directly they are stored in cash_hand_player_statistics.holecard_1 and cash_hand_player_statistics.holecard_2, or you can see the "card pair" in cash_hand_player_statistics.id_holecard.
Check the Tutorial: Custom Reports and Statistics for the card values.

[WhiteRider]

Another question. So when I see equities in replayer it is just calculated in real time right?
So there is no way to access that.

Correct.