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 olistr » Sat Jan 28, 2012 8:17 am
:( I have pop up EXPRESSION IS NOT VALID
I copy paste this
holdem_hand_player_statistics.id_hand in (SELECT holdem_hand_player_statistics.id_hand from holdem_hand_player_statistics WHERE id_player != (select setting_value::int from settings where setting_name = 'my_player_id'))
-
olistr
-
- Posts: 53
- Joined: Wed May 14, 2008 4:32 am
by WhiteRider » Sat Jan 28, 2012 2:19 pm
Sorry, I forgot you were in the tournament section. It seems that I don't have quite the right format, though. I'm sure Kraada will be able to correct it when he comes on.
-
WhiteRider
- Moderator
-
- Posts: 54025
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
by kraada » Mon Jan 30, 2012 10:41 am
For tournaments it would be:
tourney_holdem_hand_player_statistics.id_hand in (SELECT tourney_holdem_hand_player_statistics.id_hand from tourney_holdem_hand_player_statistics WHERE id_player != (select setting_value::int from settings where setting_name = 'my_player_id'))
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by olistr » Mon Jan 30, 2012 11:41 am
-
olistr
-
- Posts: 53
- Joined: Wed May 14, 2008 4:32 am
by kraada » Mon Jan 30, 2012 2:24 pm
My apologies this will validate:
tourney_holdem_hand_player_statistics.id_hand in (SELECT tourney_holdem_hand_player_statistics.id_hand from tourney_holdem_hand_player_statistics WHERE tourney_holdem_hand_player_statistics.id_player != (select setting_value::int from settings where setting_name = 'my_player_id'))
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by olistr » Mon Jan 30, 2012 3:34 pm
:( expression work, but report again write out only my hole cards only
not opponent hole cards
I loosing hope a bit that it is possible, if it is too complicated or impossible I def. can live without it
I will not get angry if you let it be ;)
-
olistr
-
- Posts: 53
- Joined: Wed May 14, 2008 4:32 am
by kraada » Mon Jan 30, 2012 4:18 pm
Do you play at multiple sites?
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by olistr » Mon Jan 30, 2012 4:53 pm
No only poker stars
-
olistr
-
- Posts: 53
- Joined: Wed May 14, 2008 4:32 am
by kraada » Mon Jan 30, 2012 6:12 pm
Do you have your screen name set via the Settings button in the main PT3 window? That is what the setting we're using in the filters corresponds to.
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by olistr » Tue Jan 31, 2012 4:46 am
If you mean settings under tournament tab next to player and site window, then yes I have set my sreen name there
-
olistr
-
- Posts: 53
- Joined: Wed May 14, 2008 4:32 am
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 0 guests