lookup handrank vs lookup handrankval ??

[petitpoisson]

Hi ,

Need to know the difference betwin this functions ?

& need to know if there is a list for id_final_hand like Top pair or set etc...

[WhiteRider]

If you click the blue "insert" link in a stat and go to the "Functions" tab you can see what each function returns.
Here "hand rank" is the text version of the hand strength and "hand rank val" is the sortable "ID" value of the hand rank.

& need to know if there is a list for id_final_hand like Top pair or set etc...

This is done with "cash_hand_player_combinations.id_f_hand_strength" (or tourney_ ...), which varies based on the type of made hand.
I believe these values are the same as they were for PT3, which are described here, but if you apply a filter for a strength of made hand you can check the queries generated in the PokerTracker4.log file from C:\Users\yourname\AppData\Local\PokerTracker 4\ (which you can access from the PT4 File menu) if you want to get some specific examples.