serverside sql WHERE key

Third Party Coronium
1

Hi dev,

When using the WHERE key as a table on serverside, only “=” is accepted. If i try “>” it fails.

I havent tried it clientside.

This can be quite the downside if you need to compare with a lot of values like for example:

where={status>0}

and status can be from 0 to 10

2

Hi,

That is noted toward the end of the docs. Lua tables don’t understand a ‘>’ so that would be very complicated to make work.

You can however use the string based version as outlined in the docs here.

So:

where = "`status` \> 0"

will do the trick.

You should make sure to use the back-ticks for valid SQL. That part is automated in the regular table version. Hope that helps.

-dev

3

Hi,

That is noted toward the end of the docs. Lua tables don’t understand a ‘>’ so that would be very complicated to make work.

You can however use the string based version as outlined in the docs here.

So:

where = "`status` \> 0"

will do the trick.

You should make sure to use the back-ticks for valid SQL. That part is automated in the regular table version. Hope that helps.

-dev