adding new column

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

adding new column

Postby meliniak » Sat Mar 03, 2012 6:29 pm

hope i didn't miss anything obvious here. i'm having problems with adding a new column to HCPS, it seems it simply isn't added at all (ie. it doesn't show up in the pgadmin). what i want to do is to add custom stat "amt won with out sd" and simply add it to custom player statistics report. i started with adding a new column amt_won_wosd defined as follow:

sum(if[holdem_hand_player_statistics.flg_showdown,0,holdem_hand_player_statistics.amt_won] )

saved it, ran all the housekeeping stuff and finally added new statistic amt_won_wosd with same expression of course being simply:

amt_won_wosd

when that stat is add to the report of mine it doesn't show up in the chart. as i have stated before, no new column is created in the hcps table. am i missing something or what? or maybe there is a simpler way to have such stat?
meliniak
 
Posts: 14
Joined: Thu Dec 31, 2009 11:15 pm

Re: adding new column

Postby WhiteRider » Sun Mar 04, 2012 6:26 am

When you create a column in PT3 that doesn't create a new entry in the database table - it is internal to PT3. (Strictly speaking, when you update the cache a new column will be added to the cache table.)

I suspect the problem will be that you haven't filled in the Format tab of your new stat so PT3 doesn't know how to display it. Make sure you fill in a Title and Width on the Format tab.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: adding new column

Postby meliniak » Sun Mar 04, 2012 7:33 am

yeah, indeed, it was about formatting the column. thanks for your help.
meliniak
 
Posts: 14
Joined: Thu Dec 31, 2009 11:15 pm


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

Who is online

Users browsing this forum: No registered users and 2 guests