position to player x

[pasita]

Any way of filtering for hands having a specific position relative to a specific player? For example hands where Hero is two seats from player x. An sql query will do if PT4 can't handle this :)

[kraada]

The only way I can think of off the top of my head to make this work is in a custom report on the My Reports page. Any SQL added in the blue Filters section will be chunked into the WHERE clause of the query that gets the report you see.

So you could do something like:

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p where p.id_player = chps.id_player and p.player_name = 'Villain Screen Name' and (chps.position - 2 = cash_hand_player_statistics.position OR (chps.position = 0 and cash_hand_player_statistics.position = 8) OR (chps.position = 1 and cash_hand_player_statistics.position = 9)))

As long as you're filtering on active player and displaying things grouped by position that should work properly (cash_hand_player_statistics.position is an outer reference in this case and refers to active player's position).

[pasita]

I may have spoken too soon.

by Stake, Position, Session and Date all give me the red treatment every second time I click "Refresh". But not when looking at Statistics, only Results.

This on one of my nicks only. Some show the red fail only occasionally (or it can be visible for ½ second before the correct rows kick in). Many of my nicks from the time have not imported at all.

[kraada]

That filter in a custom report shouldn't be affecting other reports elsewhere, so it sounds like you have something else strange going on in your database.

[pasita]

My previous post in this thread was intended to another thread (about import problems) :oops: