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 kukimus » Tue Apr 01, 2008 12:21 pm
HI
I AM LOOKING FOR THIS STAT : VAL_F_BET_MADE_PCT
BUT I CANT FIND IT IN THE CUZTOMISE SECTION..
WHERE IS IT ?
REGARDS
K.
-
kukimus
-
- Posts: 18
- Joined: Mon Mar 31, 2008 3:20 pm
by Josh » Tue Apr 01, 2008 12:24 pm
You may need to create a custom column for it. We haven't added columns for all the fields yet.
-
Josh
- Site Admin
-
- Posts: 6222
- Joined: Sat Dec 08, 2007 6:03 pm
by kukimus » Tue Apr 01, 2008 12:41 pm
[quote="Josh"2zq]You may need to create a custom column for it. We haven't added columns for all the fields yet.[/quote2zq]
ahhaaa.. but i dont now how to do the sql part.. how should it look like ? or am i missing somthing ?
-
kukimus
-
- Posts: 18
- Joined: Mon Mar 31, 2008 3:20 pm
by kukimus » Tue Apr 01, 2008 1:08 pm
ive tryed adding it but im not totaly sure how to do it..
-
kukimus
-
- Posts: 18
- Joined: Mon Mar 31, 2008 3:20 pm
by kukimus » Tue Apr 01, 2008 2:30 pm
thank you :)
can u do one more favour ? it would help me allot, how does the sql look like that calculates val_f_bet_made_pct ?
-
kukimus
-
- Posts: 18
- Joined: Mon Mar 31, 2008 3:20 pm
by Josh » Tue Apr 01, 2008 2:59 pm
That's a field in a table in the database. Check out the database schema documentation in the link I posted above.
-
Josh
- Site Admin
-
- Posts: 6222
- Joined: Sat Dec 08, 2007 6:03 pm
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 0 guests