You can use this expression filter in a custom report by clicking on the 'Filters' link and selecting 'Add New Expression Filters': char_length(cash_hand_summary.str_aggressors_p) >= 2 and char_length(cash_hand_summary.str_aggressors_t) >= 1 and lookup_actions_f.action = 'X' and cash_hand_player_sta...

Filter for: 1. Having a CBet opportunity on the flop. 2. Checking the flop and not taking a second flop action. 3. Betting the turn. (Specific Bet Opportunity Continuation Bet Opportunity) AND (First Flop Action Check) AND (NOT (Second Flop Action Any Action)) AND (Bet Turn Any Turn Bet) Guide: Filt...

For that you would need a custom expression filter that compares the rank of the turn card to the 3 flop cards: ((cash_hand_summary.card_4 - 1) % 13 < (cash_hand_summary.card_1 - 1) % 13 and (cash_hand_summary.card_4 - 1) % 13 > (cash_hand_summary.card_2 - 1) % 13 and (cash_hand_summary.card_4 - 1) ...

lookup_actions_p.action = 'CC' means that the players first preflop action was call and they took a second preflop action which was also a call (for example a player limps and then subsequently calls when facing a preflop raise).

That type of filtering will require an expression filter with a subquery but unfortunately I've been unable to come up with anything that works for this as it's beyond my SQL knowledge I'm afraid.

Unfortunately I don't know if that's feasible although if a PostgreSQL expert sees this then they might be able to offer suggest something.

Hi, so i made a backup pf PT4 on my old computer, i have a folder PT4 backup. I went to new computer to restore it, and there is no folder.. You need to transfer the backup file that was created on the old computer to the new computer. You can transfer the backup file between the computers using a ...

You can use underscores as a wildcard for any character: tourney_hand_histories.id_hand = tourney_hand_player_statistics.id_hand and (tourney_hand_histories.history like '%afteRReset (___ in chips) is sitting out%' or tourney_hand_histories.history like '%afteRReset (____ in chips) is sitting out%')

What specifically have you done? If you have created the backup file on the old computer have you transferred that backup file to the new computer? If you haven't transferred the backup file between computers then you are not going to see it if you are trying to run the restore on the new computer.

Please do not reinstall anything as that rarely fixes anything. So we can see what's happening here turn on 'Enable Logging' in PokerTracker 4 via 'Configure -> Options' and then restart PokerTracker 4. Next reproduce this issue you've described and then attach your support bundle to a Support Ticke...