SQL Question: Opponent raises you...

[Highstakes0]

How do I get a collection of every hand I participated in where:

1. Opp. raised me on the flop
2. Opp. raised me somewhere post-flop
3. Opp. bet two streats in a row
4. Opp. bet three streets in a row

Thanks a lot, I really appriciate it !

[WhiteRider]

You should be able to do most of this with the standard filters window.

Click 'Filters'.

1. I assume you mean, you bet and face a raise?
On the 'Actions' tab -> Flop, check "Bet"; go to the 'Facing' tab -> Flop and check "Face Raise".

2. Click 'Clear' to remove the previous filter.
As 1, but also check the options for other streets. Make sure that the filters are ORed and ANDed correctly for what you want - if you set them all up before clicking 'Add Selected to Filters' it should be fine.

3. If you mean that you want to find hands where a specific person bet 2 streets, you would have to select them, and set up filters for '(Bet Flop AND Bet Turn) OR (Bet Turn AND Bet River)'.
If you mean you want to find hands where you faced bets on 2 consecutive streets, currently you can't do this with Standard Filters so you would need to build a Custom Report and use the filters section there.
I'll make sure this is added to the list of filters to be added.

4. Similar to 3, but with face bet on all 3 streets.

[Highstakes0]

Oh, I forgot to say Im using PT 2.
And yeah, on nr 3, I meant two consecutive streets.

[WhiteRider]

I don't think you can do this in PT2, but I'll move this thread to the PT2 section of the forum in case Pat has anything for you.

[ptrack pat]

There is no way to do this in PT2.