Holdem Manager 2 API

[oriemsalute]

I can successfully execute a query if I include a where clause with GameNumber. If I remove the where clause I get a response "No Query Processor Found".

In the HM2 API doc it also indicates:
8. Querying for Hand Histories
It it is possible you may need to retrieve the raw hand history for a specific hand to perform custom computation. HMQL provides a very basic mechanism for the retrieval of the original hand history:

select * from handhistories where GameNumberString="5563124333"


It doesn't seem to include any example where multiple hand histories are fetched. Can you successfully retrieve multiple hand histories using a query with limit? Thanks again for any help!

[udbrky]

What is the exact query you are using so we can test it.

[oriemsalute]

What is the exact query you are using so we can test it.

select * from handhistories order by GameNumber desc limit 5

[udbrky]

What if you do

Select * from handhistories limit 5

[oriemsalute]

What if you do

Select * from handhistories limit 5

no it's not working... and I was hoping to get the 5 most recent hands, so sorting by either GameNumber desc or some recent TimeStamp would be helpful

[udbrky]

I will take a look at it and ask our API staff.

[balladar]

Hello, can I install and leave the HM2 folders in the partition where the system is not? Because my / C: it only has 120gb and I do not want to leave neither the program nor the hands there. How do I do that?

[udbrky]

You can. You want the database files in the fastest drive though.

The parent folder and postgres/data folders are the important files. The program files are pretty small.

Move all media, documents, backups, and c:\hm2archive to the second drives as well.

[SossioAruta]

Hi,

my purpose is to study all-in frequencies in mtts (obviously grouped by position), so i would like to filter stats via HMQL-query exactly the same way the More Filters>Bet size filter>Preflop/Made Bet/Open raise size does in the GUI.

Something like that:

select * from stats where EffectiveStackSizeInBBs >= 12 and EffectiveStackSizeInBBs <= 15 and FacingUnopenedPotPreflop = true and OpenRaiseSize(or whatever you want) > 10

I tried to execute a query like this through PreflopOpenPotAmountInBB itself and then through the combination of PreflopActionsString and PreflopPlayerActionAmountInBBsAllActions but i get different results comparing with the GUI.

Please help me!

[udbrky]

What are the exact queries you are running? Are there different #'s of hands than the filter itself shows?