Create database with selected types of players -efficient--

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Create database with selected types of players -efficient--

Postby dfercarrillo » Wed Apr 17, 2024 8:56 am

Hi!
I´ve been trying for some time to review my game against specific types of player.
I know I can go to "all players" reports and filter the database by #Hands, #VPIP, etc, and then I can manually color tag each player
I then create a Hands Report and filter by color tag using this expression I found here:
cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p, notes n where p.id_player = chps.id_player and n.id_x = p.id_player and n.enum_type = 'P' and n.id_color = 5)

I then select all hands and export them to a new database, and I can then review my graph, etc, against that pool of players

My question is: is there a more efficient way of skipping manually tagging each player to extract the info?

Many thanks
dfercarrillo
 
Posts: 3
Joined: Tue Aug 16, 2022 8:28 am

Re: Create database with selected types of players -efficien

Postby Flag_Hippo » Wed Apr 17, 2024 1:20 pm

You can try querying player statistics with a different filter - see this thread for an example.
Flag_Hippo
Moderator
 
Posts: 15174
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 47 guests

cron
highfalutin