literate-perfunctory
Poker Software
Page 28 of 29 FirstFirst ... 1826272829 LastLast
Results 271 to 280 of 288
  1. #271
    Member
    Join Date
    Apr 2010
    Posts
    49

    Default

    StatHighCardOnFlop is a stat, not property.

    we can't do
    select * from hands where StatHighCardOnFlop = 1 limit 100
    to find all A-high boards we can do
    select * from hands where (boardcard1 = 0 or boardcard1 = 13 or boardcard1 = 26 or boardcard1 = 39 or boardcard2 = 0 or boardcard2 = 13 or boardcard2 = 26 or boardcard2 = 39 or boardcard3 = 0 or boardcard3 = 13 or boardcard3 = 26 or boardcard3 = 39) limit 100
    it's already long query and it becomes 3 times longer if we would find K/Q-high boards using this property

  2. #272
    Junior Member
    Join Date
    Mar 2016
    Posts
    6

    Default

    Hello.
    I can't understand how i can show hands from my time list?
    This query not work:
    select * from hands where HandTimestamp in ({d "2018-03-04 10:06:20 PM"}, {d "2018-03-04 10:07:11 PM"})

  3. #273
    Member
    Join Date
    Apr 2010
    Posts
    49

    Default

    Quote Originally Posted by ZardoZ View Post
    Hello.
    I can't understand how i can show hands from my time list?
    This query not work:
    select * from hands where HandTimestamp > {d "2018-03-04 10:06:20 PM"} AND HandTimestamp < {d "2018-03-04 10:07:11 PM"}

  4. #274
    Junior Member
    Join Date
    Mar 2016
    Posts
    6

    Default

    Quote Originally Posted by kefir View Post
    select * from hands where HandTimestamp > {d "2018-03-04 10:06:20 PM"} AND HandTimestamp < {d "2018-03-04 10:07:11 PM"}
    No, This query return all hands from range. I need hands from my list only (exp my query return only 2 hands).

  5. #275
    Member
    Join Date
    Apr 2010
    Posts
    49

    Default

    select * from hands where HandTimestamp = {d "2018-03-04 10:06:20 PM"} OR HandTimestamp = {d "2018-03-04 10:07:11 PM"}

  6. #276
    Junior Member
    Join Date
    Mar 2016
    Posts
    6

    Default

    Quote Originally Posted by kefir View Post
    select * from hands where HandTimestamp = {d "2018-03-04 10:06:20 PM"} OR HandTimestamp = {d "2018-03-04 10:07:11 PM"}
    Thx. "IN" not work?

  7. #277
    Junior Member
    Join Date
    Apr 2018
    Posts
    5

    Default

    Does the HM2 API fully support Omaha? When selecting data from "hands", the HoleCards are in a variety of formats and I am not able to specify which hands are rainbow, single suited, double suited, etc:
    "HoleCards" : "J855ss"
    "HoleCards" : "J882"
    "HoleCards" : "9542o"

    Is there some documentation that lists how to interpret the preflop hands without having to reference the specific handhistories?

    Thanks!

  8. #278
    Graphics Guru fozzy71's Avatar
    Join Date
    Sep 1971
    Location
    HM Support
    Posts
    27,910

    Default

    Quote Originally Posted by oriemsalute View Post
    Does the HM2 API fully support Omaha? When selecting data from "hands", the HoleCards are in a variety of formats and I am not able to specify which hands are rainbow, single suited, double suited, etc:
    "HoleCards" : "J855ss"
    "HoleCards" : "J882"
    "HoleCards" : "9542o"

    Is there some documentation that lists how to interpret the preflop hands without having to reference the specific handhistories?

    Thanks!
    Unfortunately I do not believe it is possible to get a generic list of rainbow, SS, DS, etc using the API from what I remember when others asked about this in the past. The Custom Omaha Filter in the Reports - More Filters offers more flexibility than the API when it comes to filtering Omaha hands - Hold'Em Manager 2 FAQs - Poker Software :: Custom Omaha Filter

  9. #279
    Junior Member
    Join Date
    Apr 2018
    Posts
    5

    Default

    Does the API allow for querying handhistories over a specific time? What if I want to fetch the most recent 5 hands in my db? I notice I can add order by, and limit for the "hands" table, but not for handhistories

    Here is a sample query I'd like to perform:
    select * from handhistories order by GameNumber desc limit 5

    is it possible to add this functionality? Thanks in advance!

  10. #280
    HM2! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    18,383

    Default

    If you limit the number of hands, that should work. What exactly are you having trouble doing?
    Regards udbrky (Chris)

Page 28 of 29 FirstFirst ... 1826272829 LastLast

Similar Threads

  1. Replies: 1
    Last Post: 12-21-2011, 09:00 AM
  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, 08:20 AM
  3. Replies: 1
    Last Post: 11-08-2011, 07: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
  •