int in custom stats

[WhiteRider]

I have problems with it though. One the one hand I can use substring in the columns section only and on the other hand substring(lookup_from_id(id_flop1, 'card_rank') from 2 for 1) is not a valid SQL statement

You cannot use the lookup_from_id function in the columns. It's not valid SQL, so it can only be used in the variables and the stat expressions.

[banshee]

yes, the problem with that is that I either need lookup_from_id in the columns section (because substring only works there) or substring in the stats section (because lookup_from_id just works there). Mutual exclusion I guess

[WhiteRider]

I've mentioned this to the development team, and hopefully we will get substring available in the Stats tab at some point.