Date of last hand played

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

Date of last hand played

Postby stevi3p » Wed May 13, 2009 7:17 am

I would like to include in my report, which is based on the table "Holdem Cash Player Statistics" the date of the last hand played by the player. Is there any way of doing this, or can it only be done through creating a custom stat in the "Cash sessions" table, and then running a separate report using that table? (I could join them up in XL or whatever, but obv I'd prefer not to.)

Thanks

Steve
stevi3p
 
Posts: 71
Joined: Thu Mar 13, 2008 3:00 pm

Re: Date of last hand played

Postby kraada » Wed May 13, 2009 11:07 am

Steve,

I can't immediately think of an easy way to do this, but I'll let it percolate in my brain for a while and if I come up with anything, I'll let you know.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Date of last hand played

Postby stevi3p » Sat May 16, 2009 8:47 am

Bump. Any progress?
stevi3p
 
Posts: 71
Joined: Thu Mar 13, 2008 3:00 pm

Re: Date of last hand played

Postby kraada » Sat May 16, 2009 9:32 am

I'm afraid not; the problem is that the HHPS section can't pull out a specific detail from just one hand; you'd need a way to trick it so that only one hand matches the pattern, and I haven't found a way to do that which will work universally.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 0 guests