Holdem Manager 2 API

[maestro]

I did this query in hm2 reports->HMQL tab. Or just http://localhost:8001/Query?q=select...limit%201000;1

[mjackson]

How do I specify that hero's hole cards should be either suited or offsuit in a query?

[udbrky]

I did this query in hm2 reports->HMQL tab. Or just http://localhost:8001/Query?q=select...limit%201000;1

I still need some clarification as to what you are trying to accomplish.

Have you used offset? PHP Limit Data Selections From MySQL

This LIMIT clause would return 3 records in the result set with an offset of 1. What this means is that the SELECT statement would skip the first record that would normally be returned and instead return the second, third, and fourth records.

Let's look at how to use a SELECT LIMIT statement with an OFFSET clause in SQL.

[udbrky]

How do I specify that hero's hole cards should be either suited or offsuit in a query?

I have escalated your issue to our 2nd level support techs and they will respond to your email as soon as possible.

[mjackson]

I have escalated your issue to our 2nd level support techs and they will respond to your email as soon as possible.

I just need to replicate the hole card filters with an HMQL command. Any idea how to do that? The byte representation doesnt seem to support suited/unsuited distinctions.

[udbrky]

I just need to replicate the hole card filters with an HMQL command. Any idea how to do that? The byte representation doesnt seem to support suited/unsuited distinctions.

I did not find this, so I asked the developers.

[baddy]

Is it possible to query stats of other players? Like Vpip for player "X"?
Can you write a example query ?

Are here news?

[udbrky]

Is it possible to query stats of other players? Like Vpip for player "X"?
Can you write a example query ?

This request has been documented in detail and provided to the developers to add.

The assigned internal ticket # on this request is HM-8260

I have added your email address to the ticket so we can notify you once we have added it.

Are here news?

We do not have an ETA for this.

[tosmith42]

How can I query based the bet-size the same way as "Bet Size Filters" in "More Filters" works? There only seem to be stats for category of sizes but not for the specific bet-size that I wish to explore.

[udbrky]

What bet-size are you not able to use? It's % of pot and has less than, greater than, equal to and between capabilities.