Report -Filter for specific player ID

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Report -Filter for specific player ID

Postby denutza » Sun Feb 20, 2011 12:57 pm

The following works perfect in Omaha Cash Hand Section, but not in Player Statistics, Report Section:

omaha_hand_player_statistics.id_hand in (SELECT omaha_hand_player_statistics.id_hand from player, omaha_hand_player_statistics
WHERE player.id_player = omaha_hand_player_statistics.id_player and omaha_hand_player_statistics.id_player=77 and omaha_hand_player_statistics.flg_p_first_raise and
omaha_hand_player_statistics.position=8 )

It shows something like 44 Hand #'s in the hand section, and just as i want, player with ID 77 is in the BB, etc..

When I run it in the playerstatistics section, it shows 140,000+ hands were filtered, which cant be right.

Im choosing to use the Id_player method for speed.
denutza
 
Posts: 105
Joined: Fri May 23, 2008 2:01 am

Re: Report -Filter for specific player ID

Postby kraada » Sun Feb 20, 2011 1:07 pm

That's odd, I don't see why that wouldn't work properly.

Try this and see if it works better:

omaha_hand_player_statistics.id_hand in (SELECT omaha_hand_player_statistics.id_hand from omaha_hand_player_statistics
WHERE omaha_hand_player_statistics.id_player=77 and omaha_hand_player_statistics.flg_p_first_raise and
omaha_hand_player_statistics.position=8 )

If not, what stats are you displaying in your report?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Report -Filter for specific player ID

Postby denutza » Sun Feb 20, 2011 1:18 pm

Still not working..

Just displaying BB/100 and Hands in Player Section....And Hand # in Hand section.

No matter what value I set Player_Id to, it always reports the same 145,000 hands. I also tried a different SQL command using player_name_search that also
just reports 145,000 hands.

Filter on Active Player is checked.
denutza
 
Posts: 105
Joined: Fri May 23, 2008 2:01 am

Re: Report -Filter for specific player ID

Postby kraada » Sun Feb 20, 2011 2:06 pm

Could you export, zip up and attach the report to a support ticket? I'll take a look at it for you.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests