Hands Note

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

Hands Note

Postby FilS2BotS » Sat Nov 20, 2010 5:15 pm

I would like to have a stat that allow me to put whatever i want to recognize it/
e.g.: I want the hands where i do a bad call a stat hat say BC
when i do a bad bluff the stat write BF

I mean i do my review and instead of writing BC or BF in the note i would like to see that appear in a stat that i custom when i do my review...
TY
FilS2BotS
 
Posts: 149
Joined: Wed May 05, 2010 2:20 am

Re: Hands Note

Postby kraada » Sun Nov 21, 2010 9:56 am

I'm not exactly sure what you're asking. Is there a reason taking notes on the individual hands isn't sufficient for you?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Hands Note

Postby FilS2BotS » Sun Nov 21, 2010 10:30 am

i mean i would like to be able to do a report that ll hold only the hands with the specific note i want... not just be able to hold all the hands with notes... a stat with the note direct on the report
FilS2BotS
 
Posts: 149
Joined: Wed May 05, 2010 2:20 am

Re: Hands Note

Postby kraada » Sun Nov 21, 2010 10:34 am

You can do this with a specific filter in the custom report. In the blue Filters section add the following:

notes.notes = 'Your Text Here'

Save the filter (changing the text as appropriate) and that should filter only to hands with the notes that match the text you input.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Hands Note

Postby FilS2BotS » Sun Nov 21, 2010 12:28 pm

i have hands with the note: NH
i puted notes.notes = 'NH' in the blue filter and it takes hour for the populating...
so i had a specific day and it holded me some hands... all of them does not have note in it and the reports put each hands 4 times...
FilS2BotS
 
Posts: 149
Joined: Wed May 05, 2010 2:20 am

Re: Hands Note

Postby kraada » Sun Nov 21, 2010 1:00 pm

Try this filter instead:

holdem_hand_player_statistics.id_hand in (SELECT n.id_x from notes n where n.notes = 'Your Text Here')

And see if that works better 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