PokerTracker

I understand how get, for example PocketCards by ID - "lookup_from_id( id, 'cardpair')". But I can not find in documentation how get PlayerName by ID...

There are only this valid lookups: 'blindsbb', 'blindsdesc', 'sitename', 'siteabbr', 'cardpair', 'card', 'card_rank', 'finalhand', 'month', 'tourneytabletype', 'tourneytype'

What can I do when I whant get some informatin from lookup tables by ID exclude valid lookups (PlayerName for example).

Thanks.

You need to use the column for the player name if it's available, if not you need to create one linking to the player.player_name database field.

You could run your own query against the table 'player' using the query tool in pgAdmin.
Here is the SQL statement:

Code: Select all

SELECT player.player_name, player.id_player
FROM player
WHERE player.id_player > 0
ORDER BY player.player_name ASC


Chuck