Holdem Manager 2 API

[alecireddu]

Try using this: "DateTime" > {"1/1/2012 10:00:00 PM"}

Hi,
i try in the HMQL report differents syntax :

• select * from hands where HandTimestamp > {"1/1/2012 10:00:00 PM"}
• select * from hands where "HandTimestamp" > {"1/1/2012 10:00:00 PM"}
• select * from hands where DateTime> {"1/1/2012 10:00:00 PM"}
• select * from hands where "DateTime" > {"1/1/2012 10:00:00 PM"}

but i get always a similar error: invalid character '{'} at...

Thank you

[fozzy71]

We have forwarded your questions/problems to the developer in charge of the HMQL and will forward his reply once he has had time to review the questions.

[udbrky]

I apologize for the delay. It is not possible currently to do this, but it should be available in our next release. This is the format you would use:

select * from hands where HandTimestamp > {d "2008-10-16 02:16:00 AM"}

[alecireddu]

I apologize for the delay. It is not possible currently to do this, but it should be available in our next release. This is the format you would use:

select * from hands where HandTimestamp > {d "2008-10-16 02:16:00 AM"}

Thank you,
can you specify the next release where i can found the fix?

Thanks

[udbrky]

I will clarify that and get back to you.

[fozzy71]

It should be available to you in the next beta or official release we push but we can't give an ETA for when the next release will be. It was a quick change by the developer without a ticket so it likely won't show up in the release notes.

[fozzy71]

FYI the new/fixed date formatting is in beta 8227 - http://forums.holdemmanager.com/hm2-...ignatures.html

Beta updated to 2.0.9.8227.

Changes in latest beta:
- HM-8526 PokerStars - Improvements for Zoom HUD after Pokerstars client update (Build 8809)
- HM-8506 FullTilt Rush - Added list of winners in table HUD
- HMQL - Added "yyyy-MM-dd hh:mm:ss tt" format to HMQL DateTime where clause

[alecireddu]

FYI the new/fixed date formatting is in beta 8227 - http://forums.holdemmanager.com/hm2-...ignatures.html

Thank you...but can you indicate me the correct syntax in HMQL?
Before the update the syntax
select StatNetAmountWonEUR from stats where HandTimestamp > {d "2014-10-20"}
works
After the update the previous syntax no longer works

Pleas help me

[fozzy71]

I will forward this question to the developer.

[fozzy71]

Thank you...but can you indicate me the correct syntax in HMQL?
Before the update the syntax
select StatNetAmountWonEUR from stats where HandTimestamp > {d "2014-10-20"}
works
After the update the previous syntax no longer works

Pleas help me

Try this new build - http://www.holdemmanager.com/Downloa...pdate_8229.exe

The query above in bold seems to work for me. Let us know if you have any problems with this or other queries.