Separate Reg and fish in hand reports

[Gustinhio]

Hello,

I'm working on my data base and i want to know if it's possible to seperate in Hands reports players who have more than XX hands and players who having less than XX hands

[Flag_Hippo]

What exactly do you mean when you say "separate"? Are you playing heads up poker only? Or are the hands you've played multiway? Multiway hands can have players with both less than 'x' hands and more than 'x' hands. Also are you trying to view the hands only from your perspective or from the perspective of the player with 'x' hands? If you could please provide more information on what it is you are trying to achieve in this hand report that would be helpful. Thank you.

[Gustinhio]

My goal is to be able to go to the Hand Report tab and apply filters to analyze a situation.

In addition, I'd like to choose to display only opponents who have played fewer than XX hands or more than XX hands against me.

I'm a Spins player.

[Flag_Hippo]

This expression filter will return hands where one of your opponents had less than 50 hands:

Code: Select all

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))) < 50)))

You can edit that as required for the hand counts you want to filter for. You can use this expression filter in a custom 'Hand Report' by clicking on the 'Filters' link and selecting 'Add New Expression Filters'. If the filter gives an error you will need to change the hands dropdown to 'Max Hands'.

[Gustinhio]

So are we okay ?

It will take the overall hands of vilain ?

Exemple i want to look at one filter spot it will take all hands played by players who i have less than 50 hands in my overall database ?


I used ur filter wait during 2 hours and it's not working

[Flag_Hippo]

It will take the overall hands of vilain ?

Yes but not a specific villain. The filter uses a subquery to check every player dealt into the hand and it will be true if at least one of those players meets the requirement.

I used ur filter wait during 2 hours and it's not working

If you are using other filters then you should add those as additional expression filters instead of using built-in filters. If you're not sure what to use then with the method described here you can check the query in the log file or you can extract what you need from a relevant custom column that does the same thing for a stat. Please note that query performance using subqueries will degrade the larger the database is.