Holdem Manager 2 API - Page 29
Page 29 of 31 FirstFirst ... 192728293031 LastLast
Results 281 to 290 of 308
  1. #281
    Junior Member
    Join Date
    Apr 2018
    Posts
    5

    Default

    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!

  2. #282
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    What is the exact query you are using so we can test it.
    Regards udbrky (Chris)

  3. #283
    Junior Member
    Join Date
    Apr 2018
    Posts
    5

    Default

    Quote Originally Posted by udbrky View Post
    What is the exact query you are using so we can test it.
    select * from handhistories order by GameNumber desc limit 5

  4. #284
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    What if you do

    Select * from handhistories limit 5
    Regards udbrky (Chris)

  5. #285
    Junior Member
    Join Date
    Apr 2018
    Posts
    5

    Default

    Quote Originally Posted by udbrky View Post
    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

  6. #286
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    I will take a look at it and ask our API staff.
    Regards udbrky (Chris)

  7. #287
    Junior Member
    Join Date
    Jul 2018
    Posts
    11

    Default

    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?

  8. #288
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    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.
    Regards udbrky (Chris)

  9. #289
    Junior Member
    Join Date
    Oct 2018
    Posts
    7

    Default

    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!

  10. #290
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

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

Similar Threads

  1. Replies: 3
    Last Post: 12-02-2018, 05:29 PM
  2. How Do I Import hands from holdem manager 1 to holdem manager 2?
    By rockstarhobbo in forum General Support
    Replies: 5
    Last Post: 11-11-2011, 09:20 AM
  3. Replies: 1
    Last Post: 11-08-2011, 08:06 PM
  4. Replies: 1
    Last Post: 08-30-2011, 09:58 PM
  5. Latest version of Holdem Manager killed Holdem Manager
    By TLXLM in forum Manager General
    Replies: 2
    Last Post: 09-06-2008, 11:09 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •