Hello, I was rereading this thread, https://www.pokertracker.com/forums/vie ... er#p368365
And he is close to what I am looking for, but I intend to do it against a group of players,
I tried this code, with a specific player in a hands report and I entered this code with a specific player, in the filters.edit existing expression filters section and perfect.
tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps, player p where thps.id_player = p.id_player and p.player_name = 'VILLAIN')
Now I ventured and replaced Villan with RegularPlayerList.player and the query did not validate. It stays like this
tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps, player p where thps.id_player = p.id_player and p.player_name = RegularPlayerList.player)
RegularPlayerList is a view that I have created inside the database that pt4 created in potgress, and player_name is the column where it stores the names of the regulars that I decided.
This view has more columns, like id.player and id.site, all the columns are populated through a function, which I feed with the players' names and if the players are in the database, then it adds them to the list. player list, with the real id of the BD and the real Id.site to which that nick belongs.
Final question. How can I make a filter query, so that it shows me hands in which I was at the same table, and at least one of the players in the playerList?
Thanks for reading my post