Help required with 1st query please

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Help required with 1st query please

Postby 32Ford » Mon Jun 30, 2008 4:22 pm

Hi
I'm completely new to PokerTracker and have just purchased v3.
Could someone give me a step by step guide to creating my 1st d/base query please.
I'd like to know my win/loss total for a range of dates.
I've spent some time trying to fathom this out, but all to no avail. I've read the examples from 2+2 but can't find a date range one. I know that once given an example, I'll be able to move on. It's just getting the first one thats the problem for me.
Thanks in advance for any help
Steve
32Ford
 
Posts: 21
Joined: Mon Jun 30, 2008 3:30 pm

Re: Help required with 1st query please

Postby WhiteRider » Mon Jun 30, 2008 4:33 pm

Are you trying to do this outside PT3?
From within, you can just use the Filter section to filter by date..
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Help required with 1st query please

Postby 32Ford » Mon Jun 30, 2008 4:48 pm

Ok, thanks. Yes, within PT. I've just realised how to do it. I didnt spot the date range at the top (doh!)

Just one other point though, I had PT running for maybe 20 minutes and it had imported 60 hands or so whilst playing. I stopped the auto import and ran the filter and the display simply said "loading". I closed PT down, started up again, added the filters and this time it displayed straight away.

Is there a bug there ?
32Ford
 
Posts: 21
Joined: Mon Jun 30, 2008 3:30 pm

Re: Help required with 1st query please

Postby WhiteRider » Mon Jun 30, 2008 4:53 pm

If you can reproduce it, please report it as a bug.
However, after importing, to see the new hands you need to click the Refresh button first.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 6 guests