PokerTracker

Hi,

i'd want to select hands according to opponent stack.
Especially when me and one opponent have an equal stack. That is not possible with "effective stack" or "short stack".

So i try to construct an expression filter, but that's failed: "tourney_hand_player_statistics.amt_before = (tourney_hand_player_statistics.amt_before where flg_hero = false)" is not valid.

Someone with better skill in SQL can help me to select this type of hands ?

Thank you very much

Testing the stack size of another player would require an expression filter with a subquery however I don't know of a method within that to compare the size of stacks between players.

I think we need to query stack of player according to id in DB.
All variables are in table "tourney_hand_player_statistic", so we have to request this table by id_hand.

Questions are:
is it possible within filter box of a report ?
what is the select query to do that ?

I need help for these 2 questions

I search some tips to do that.
And i think we need to create intermediate tables like this:
CREATE TABLE hero_stack AS
SELECT id_hand,amt_before FROM tourney_hand_player_statistics thps
WHERE thps.flg_hero = true

CREATE TABLE vilain_stack AS
SELECT id_hand,amt_before FROM tourney_hand_player_statistics thps
WHERE thps.flg_hero = false

and to do stack comparisons with a join by id_hand where hero_stack.amt_before = vilain_stack.amt_before

Do you think it can work ?
I tested to use "create table" within filter box of pokertracker but says me "expression not valid": what is the problem ? My request ? Or it's not possible to create a table inside pokertracker ?

You can only create database tables outside of PokerTracker 4 however that's beyond the scope of our support.