Player-Report grouped by Flop-Texture

[Olaf72]

I'd like to generate a Player-Report that groups by different Flop-Textures.

Grouping would be:
Number of Broadway-Cards (0,1,2,3)
Suits (monochrome,2-suits,rainbow)
Pairing (no Pair, high Pair, low Pair, Trips)

So i need coresponding Database-Columns. I have no Idea how to do this.
With Filters it's easy, but no clue how to do it in SQL?

Please help :)

[kraada]

The easiest way to see how these are all put together is to actually look at the SQL queries PT4 uses when building those exact filters. To do that, start PT4 with the Logging Enabled link on your start menu, run any report a simple custom report (just having number of hands might make it easiest to see what's going on) with the filter you want to look at enabled.

Then open up our log file in any text editor - click File -> Open User Data Folder and the text file called PokerTracker4 is the one you want to look at. At the very bottom you'll see the SQL for the last query run and it should clarify how to set these various things up - the bits you're looking for use cash_hand_summary.card_1 through card_3 (those are the flop cards).