Steal vs Me report

[kydechuk01]

I'm trying to construct custom report for players in my base like this

Player | Hands | Att to Steal - CO | Att to Steal - BTN | Att to Steal - SB

I already made custom stats for Steals, and now Iam confused how to correctly finish the expression filter to sort only hands where I was on the blinds (position 8 to 9).

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 = 'My Name' and XXXXX? )

Kraada, can you help me?

[kraada]

(chps.position = 8 or chps.position = 9)

You'll want the ()s to keep that piece together also.

[kydechuk01]

(chps.position = 8 or chps.position = 9)

You'll want the ()s to keep that piece together also.

Oh Yeah! It works, thanks! Tried p.position and it was wrong.

BTW this is a very good kind of reports... =)

[kydechuk01]

And another question. Can I build a custom column based on the expression like above? At least theoretically, for using it by the special version of the HUD in the replayer (there I can wait while it calculates).

Example:
cnt_steal_att_co_vs_me:

sum(if[cash_hand_player_statistics.flg_steal_att and cash_hand_player_statistics.position = 1 AND (player_name 'MyName' position = 8 OR player_name = 'MyName' position = 9) , 1, 0])

[kraada]

That's not going to work as you have it formulated - the subselect gets the id_hands for the hands that match you - what you've done is just make it so that it only adds up if the player is you and for all players that aren't you that will just not add anything.