In the 'holdem cash hand' section of Custom Reports, you can work with your hole cards.
These are stored in the database as numeric values in fields:
holdem_hand_player_statistics.id_holecard - your pair of cards
holdem_hand_player_detail.holecard_1 - your first hole card
holdem_hand_player_detail.holecard_2 - your second hole card
In PT4 these database fields are:
(The values are the same for PT4)
[When building Statistics, but not in Columns..]
You can convert the numbers into human readable strings using the lookup_from_id Function.
lookup_from_id( id_holecard, 'cardpair' ) - e.g. "AA", "KQs", "62o". (note the single quotes round 'cardpair')
lookup_from_id( id_holecard1, 'card' ) - e.g. "As", "Td", "5c".
lookup_from_id( id_holecard1, 'card_rank' ) - returns a numeric value of the card strength. A=14, K=13, ... 2=2
As a reference guide, the 'cardpair' and 'card' lookup values are as follows:
KQs=27 .. K2o=48
QQ=49, JJ=70, TT=89, 99=106, 88=121, 77=134, 66=145, 55=154, 44=161, 33=166, 22=169
2c=1 / 2d=14 / 2h=27 / 2s=40
3c=2 / 3d=15 ...
Ac=13 / Ad=26 / Ah=39 / As=52
There are some other DB fields related to cards, and the same lookup functions can be used:
..are the board cards.
To check for board cards if you don't know the suit, you can use this kind of filter:
id_flop1 % 13 = 0
..which is the MOD function, and will find any aces (any time the ID divided by 13 leaves a remainder of 0, i.e. 13, 26, 39, 52).
Note: if you search for aces as above it will also count when ID=0 which it is if there is no flop, so you need to check this:
id_flop1 % 13 = 0 AND id_flop1 > 0