Copying / Pasting PT3 Popup & Hud Stats

[Equallizer]

In the REPORT STATS box I have inserted the following:

Player
Hands
VP$IP
PFR
Amount Won


So when I copy and pasted your formula

player.id_player in (SELECT p.id_player from player p, holdem_hand_player_statistics hhps where hhps.id_player = p.id_player and extract(year from hhps.date_played) = extract(year from now()) and extract(doy from hhps.date_played) = extract(doy from now()))


into Filters option and run the report, I see all the players in the Players List but the report is completely empty wuth bottom headings of:

Players 0 0.00 0.00 0

Runing 3.09.1 Beta

[WhiteRider]

That filter works OK for me.
Have you unticked "Filter on Active Player"?

[Equallizer]

Some progress: I am getting something now and only thing different is that I restarted PT3 (morning/night)

What I am getting now is only MY Name and stats. If I click on active and select another player that I played against today I get nothing.

To help troubleshoot, Can you give me the correct formula to just display players Names that I played against today and the proper settings?

Do I need to set the Dates option = Today?

[kraada]

That should be working - in the blue Filters section do you have "Filter on Active Player" unchecked? You also don't want any general filters - they aren't necessary.

[Equallizer]

That should be working - in the blue Filters section do you have "Filter on Active Player" unchecked? You also don't want any general filters - they aren't necessary.

Correct.

So what is the basic formula to just get the player's name displayed that I played against today in the reports?

[WhiteRider]

I'm not sure what you mean? You display the player name by adding the Player stat to the report - that is nothing to do with the filter. Paste the filter Kraada gave you above into the window that opens when you click the blue filters link, and click Save so that it appears at the top. Untick 'Filter on Active Player' and click OK.
Add whatever stats you want to the report and run it.
I'm not at my normal computer just now, but if you can't get it working please let us know and either Kraada or I will attach the report for you tomorrow.

[Equallizer]

This is what I have so far:

I can run the report with Filter on Active Player and it will display my stats.(name, hands, vpip, pfr, amount)

If I uncheck this, I still get only my name and stats.

If I go to the list and select another player, view their stats in DETAILS and then run the report (still Active Player Checked), I only get the headings
of Players followed by zeros in the rows at the bottom of the report.

If I uncheck the Filter on Active player while the ANOTHER player is still enabled and run the report, I still only get my name and stats.

[WhiteRider]

OK, thanks - either Kraada or I will post the report for you later.

[kraada]

I've built and attached the report to this post for you - I just tested and it does work for me.

[Equallizer]

I guess I didn't make myself clear

I

f I select in the Tournaments -Filters - Played Today

This works perfect for the Cash games ( which I would have needed as well) but I was trying to get this work under

Holdem Tournament s Player Statistics

Sorry for the confusion.