Compare your stack to opponents

[bennet]

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

[Flag_Hippo]

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.

[bennet]

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

[bennet]

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 ?

[Flag_Hippo]

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