new with SQL

[c666666]

Hi,
I'm starting to use the SQL with PT3. I have a question.

For example:
sum(if[holdem_hand_player_statistics.flg_f_cbet_opp, 1, 0])
What does mean the last 1 and 0 ( ,1,0) ? Where can I find more information about this type of questions for beginners?

Thanks

[kraada]

This is a column definition in the Holdem Cash Player Statistics section. When a column is calculated there, it loops over every hand for each player.

What it does here is sum up all of the results for each hand (hence the sum()).

What does it sum up?

In this case:

if[holdem_hand_player_statistics.flg_f_cbet_opp, 1, 0]

Which means if holdem_hand_player_statistics.flg_f_cbet_opp (you had a chance to cbet the flop), add 1, otherwise add 0.

So the result is a sum of how many chances you had to cbet the flop.

[WhiteRider]

Custom Statistics and Reports FAQ.