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
by 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
by 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
by 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
by 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
by 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
by 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]
Users browsing this forum: No registered users and 0 guests