Hands Against Fish or Reg by Number of Hands

[Gustinhio]

Hello,

I'm looking to find a way to have (in tournament) the possibility to create a filter in HU if the players have more than 30 hands or less in my database.
I find the way to filter the players but i don't find the way to do it in hands report

[Flag_Hippo]

Code: Select all

tourney_hand_summary.cnt_players = 2 and tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, tourney_cache tc where thps.id_player = tc.id_player group by thps.id_hand, thps.id_player having ((((sum(tc.cnt_hands))) < 30)) and not thps.flg_hero)

You can use this expression filter in a custom hand report by clicking on the 'Filters' link and selecting 'Add New Expression Filters'.

[Gustinhio]

Hello,

I tried this filter unfortunatly it's always staying in loading... and i cannot see any hands

[Flag_Hippo]

If you are using any built-in filters such as for the number of players please remove them. I included a filter for the number of players in the expression filter for this reason. If you are not using any other filters then this type of filter can still generate a lot of PostgreSQL processing so can take a while to complete if you have a large database. You could also experiment with the filter in a smaller database and check the results returned there.