Page 1 of 1

adding new column

PostPosted: Sat Mar 03, 2012 6:29 pm
by meliniak
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?

Re: adding new column

PostPosted: Sun Mar 04, 2012 6:26 am
by WhiteRider
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.

Re: adding new column

PostPosted: Sun Mar 04, 2012 7:33 am
by meliniak
yeah, indeed, it was about formatting the column. thanks for your help.