How get PlayerName by ID

[kpalych]

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.

[Josh]

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.

[Seitz333]

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