Invalid Expression - The statement is not valid SQL

[OneKef]

Good evening!

Trying to create custom stats (following this thread https://www.pokertracker.com/forums/viewtopic.php?f=61&t=95858&p=346030#p346030 ) when I go to save,report that error in object.
What does it mean?
Thank you :)

[Flag_Hippo]

It means the expression you are using isn't valid and has a mistake. Please copy/paste exactly what you are using here so we can see where the problem is.

[OneKef]

Hi, thanks for the answer!
I am using this , trying to clone and modify the RFI ,to create it by stack , in this case from 10 to 20bb :

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_first_raise AND tourney_hand_player_statistics.flg_p_open_opp, 1, 0])AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 AND 20

I'm also trying to change something , comparing what I can find here , but nothing .
:heart:

[Flag_Hippo]

The code from the database schema needs to be contained within the sum(if[, 1, 0]) like this:

sum(if[tourney_hand_player_statistics.flg_p_first_raise AND tourney_hand_player_statistics.flg_p_open_opp AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 AND 20, 1, 0])

[OneKef]

Always thanks!

thanks to your clues maybe I got to something,I will update.