Filters

[ridodirado]

If I assign a color label to a certain player type, can I filter hands based on that label? For example, if I assign yellow to calling stations, can I filter all hands where I played against a CS?

[Flag_Hippo]

That will require a custom expression filter in a custom hand report:

Guide: Creating My Reports

Cash:

Code: Select all

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, notes n WHERE chps.id_player = n.id_x AND (n.id_color = 1))

Tournament:

Code: Select all

tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps, notes n WHERE thps.id_player = n.id_x AND (n.id_color = 1))

You can use expression filters in a custom hand report by clicking on the 'Filters' link and selecting 'Add New Expression Filters'. 1 for id_color is yellow, 2 is green and so on in the order of the colors listed in the note editor. If using the expression filter gives an error in your hand report change the hands dropdown to 'Max Hands'.

[majonyjony]

That will require a custom expression filter in a custom hand report:

Guide: Creating My Reports

Cash:

Code: Select all

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, notes n WHERE chps.id_player = n.id_x AND (n.id_color = 1))

Tournament:

Code: Select all

tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps, notes n WHERE thps.id_player = n.id_x AND (n.id_color = 1))

You can use expression filters in a custom hand report by clicking on the 'Filters' link and selecting 'Add New Expression Filters'. 1 for id_color is yellow, 2 is green and so on in the order of the colors listed in the note editor. If using the expression filter gives an error in your hand report change the hands dropdown to 'Max Hands'.

This works if he plays HU, right?

[Flag_Hippo]

This works if he plays HU, right?

That will work regardless of the number of players dealt into the hand.