Connectedness on Turn

[corvet]

I need use "Connectedness on Turn Any Made Straight is Possible" in expression filter , but it doesnt work

Any other way to do it ?

Thank you

[Flag_Hippo]

I cannot reproduce the issue in your screenshot. Does the filter work if you create and use a default hand report? You are not using a default hand report in your screenshot and I can't see all of the statistics you are using and there may be a conflict with some of the statistics you have added. You can remove statistics and refresh the report to see which ones might be causing the error.

[corvet]

Quick filter works but i need expression filter
I copied request from SQL log file, expression filter is valid but doesnt work


((((((((tourney_hand_summary.card_4 > 0 AND ( ((((1 << (tourney_hand_summary.card_1 % 13)) | (1 << (tourney_hand_summary.card_2 % 13)) | (1 << (tourney_hand_summary.card_3 % 13)) | (1 << (tourney_hand_summary.card_4 % 13))) & (31<<0) )>>0 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (tourney_hand_summary.card_1 % 13)) | (1 << (tourney_hand_summary.card_2 % 13)) | (1 << (tourney_hand_summary.card_3 % 13)) | (1 << (tourney_hand_summary.card_4 % 13))) & (31<<1) )>>1 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (tourney_hand_summary.card_1 % 13)) | (1 << (tourney_hand_summary.card_2 % 13)) | (1 << (tourney_hand_summary.card_3 % 13)) | (1 << (tourney_hand_summary.card_4 % 13))) & (31<<2) )>>2 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (tourney_hand_summary.card_1 % 13)) | (1 << (tourney_hand_summary.card_2 % 13)) | (1 << (tourney_hand_summary.card_3 % 13)) | (1 << (tourney_hand_summary.card_4 % 13))) & (31<<3) )>>3 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (tourney_hand_summary.card_1 % 13)) | (1 << (tourney_hand_summary.card_2 % 13)) | (1 << (tourney_hand_summary.card_3 % 13)) | (1 << (tourney_hand_summary.card_4 % 13))) & (31<<4) )>>4 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (tourney_hand_summary.card_1 % 13)) | (1 << (tourney_hand_summary.card_2 % 13)) | (1 << (tourney_hand_summary.card_3 % 13)) | (1 << (tourney_hand_summary.card_4 % 13))) & (31<<5) )>>5 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (tourney_hand_summary.card_1 % 13)) | (1 << (tourney_hand_summary.card_2 % 13)) | (1 << (tourney_hand_summary.card_3 % 13)) | (1 << (tourney_hand_summary.card_4 % 13))) & (31<<6) )>>6 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (tourney_hand_summary.card_1 % 13)) | (1 << (tourney_hand_summary.card_2 % 13)) | (1 << (tourney_hand_summary.card_3 % 13)) | (1 << (tourney_hand_summary.card_4 % 13))) & (31<<7) )>>7 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (tourney_hand_summary.card_1 % 13)) | (1 << (tourney_hand_summary.card_2 % 13)) | (1 << (tourney_hand_summary.card_3 % 13)) | (1 << (tourney_hand_summary.card_4 % 13))) & (31<<8) )>>8 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (tourney_hand_summary.card_1 % 13)) | (1 << (tourney_hand_summary.card_2 % 13)) | (1 << (tourney_hand_summary.card_3 % 13)) | (1 << (tourney_hand_summary.card_4 % 13))) & (31<<9) )>>9 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (tourney_hand_summary.card_1 % 13)) | (1 << (tourney_hand_summary.card_2 % 13)) | (1 << (tourney_hand_summary.card_3 % 13)) | (1 << (tourney_hand_summary.card_4 % 13))) & ((31<<9)+1)) IN ( 1537, 2561, 3073, 4609, 5121, 6145, 3585, 5633, 6657, 7169 )))))))))))

[Flag_Hippo]

Unfortunately there is an issue with how the expression is being converted into a query and I don't have a workaround for that using an alternative expression. Depending on what you want you can use the built-in filter for the board texture and use expression filters for anything else you need.

[corvet]

Ok i need situations when
Connectedness on Turn Any Made Straight is Possible + Turn is overcard to second flop card (for example flop AT7 , turn is J-K)

How i can joined it without expression filter ?

[Flag_Hippo]

Use the built-in filter for (Connectedness on Turn Any Made Straight is Possible) along with this expression filter:

Code: Select all

(tourney_hand_summary.card_4 > 0 AND ((((tourney_hand_summary.card_4 + 12) % 13) > ((tourney_hand_summary.card_1 + 12) % 13) AND ((tourney_hand_summary.card_4 + 12) % 13) > ((tourney_hand_summary.card_2 + 12) % 13) AND ((tourney_hand_summary.card_4 + 12) % 13) < ((tourney_hand_summary.card_3 + 12) % 13)) OR (((tourney_hand_summary.card_4 + 12) % 13) > ((tourney_hand_summary.card_1 + 12) % 13) AND ((tourney_hand_summary.card_4 + 12) % 13) < ((tourney_hand_summary.card_2 + 12) % 13) AND ((tourney_hand_summary.card_4 + 12) % 13) > ((tourney_hand_summary.card_3 + 12) % 13)) OR (((tourney_hand_summary.card_4 + 12) % 13) < ((tourney_hand_summary.card_1 + 12) % 13) AND ((tourney_hand_summary.card_4 + 12) % 13) < ((tourney_hand_summary.card_2 + 12) % 13) AND ((tourney_hand_summary.card_4 + 12) % 13) > ((tourney_hand_summary.card_3 + 12) % 13))))

[corvet]

Sorry I meant

Connectedness on Turn Any Made Straight is Possible or Turn is overcard to second flop card

[Flag_Hippo]

Those filters need to be joined with OR so unfortunately they can't be used together since the possible turn straight expression filter generates the error and the turn overcard filter based on the second ranked flop card cannot be done with a built-in filter.