Filter "vs specific player"

[cntgetmedown]

Thanks kraada.

[cntgetmedown]

Hi. Today I was trying to use this same filter with VPIP=true for a pair of players. So say for example I would want to run a report with hands where a pair of players were sitting at my table, how would I do this?

I tried taking the original code and adding another and condition to the end. So this:

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p where chps.id_player = p.id_player and p.player_name = 'Villain Name' and chps.flg_vpip)

to this:

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p where chps.id_player = p.id_player and p.player_name = 'Villain Name1' and p.player_name = 'Villain Name2' and chps.flg_vpip)

The second expression validates, but I get no hand results. I know for sure that I have logged hands vs the accounts in question. Can you tell me if this is possible and how to fix the code?

Thanks.

[cntgetmedown]

Also, it would be nice if the player pairs could be filtered by an or condition. For example p1+p2 or p1+p3 etc.

[kraada]

That won't work because each player only has one name -- the way it's written it tests each player in the hand who put money in to see if their name matches both of those names (which never happens.

The best way to do this is to just add a second filter for the second player's name same as the first. This will cause the report to take longer as a result, but it's the simplest way to make sure both players are there.

[cntgetmedown]

Ok, thanks, I'll give that try.

[potamito]

There wasn't a filter for that in PT3, but you can do this with a custom filter expression in the My Reports area.

The filter:

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p where chps.id_player = p.id_player and p.player_name = 'Villain Name')

Will filter to all hands where Villain Name was dealt in. Note that you need the single quotes around the opponent's screen name.

You can use this in the My Reports tab then filter as you'd like further to see things from your perspective.

I can do this in Result/Hero vs Villain but im not intrested on just see the hands where both of us were dealt in, i want to filter the hands when we actually played a hand.

[BillGatesIII]

Code: Select all

cash_hand_player_statistics.flg_vpip
and cash_hand_player_statistics.id_hand in (
  select chps.id_hand
  from cash_hand_player_statistics chps, player p
  where chps.id_player = p.id_player
  and p.player_name = 'Villain Name'
  and chps.flg_vpip)

[klippan]

hi,

I understand how I can filter for "vs specific player" on the My Reports Tab, but can I do anything similar on the Statistics tab as well?

Thanks,

[kraada]

No, the filter expressions are only available on the My Reports page.

[sawwee]

You can create a custom stat and use it on "Statistics" tab.