Table Type

[zedjr]

We want to get the stats based on different table types (6Handed or 9Handed). How do we determine the table type?
We couldn't find a specific field in the database that contains this information.

[kraada]

The data on the limits is stored in the holdem_limit table.

[zedjr]

Thanks for the reply but I am actually asking on how you would determine that a statistic is for a 9 handed table or a 6 handed table and not on the table limit.

[kraada]

Now I'm not certain exactly what you're asking - if you want data only from a certain table type, you can join to the holdem_limit table and restrict the table type that way. The data in the PT3 database isn't stored as statistics, it's stored as data, and then the statistics are generated from it . . .

[zedjr]

Am just trying to get whether it is a short handed or full ring and dont care about the limits or otherwise.

[WhiteRider]

You can filter for the number of active players in each hand using the normal Filters, on the General tab, or you could select all of the limits labelled "(6 max)" there too.

If you're trying to build a custom statistic based on the table size you could use an expression like:

holdem_limit.limit_name LIKE '%(6 max)'

..which means any number of characters followed by (6 max).
If you tell us exactly what you are trying to do we'll gladly help you work out how to do it.