'IN' in command selectdb
Author: ivanandradesantana@gmail.com (IvanSantana)
I wonder if this way works selectdb "selectdb sum (field) of" tables "u_where key in (1.2) to value" using the '=' as the 'IN' command database
Author: ivanandradesantana@gmail.com (IvanSantana)
I wonder if this way works selectdb "selectdb sum (field) of" tables "u_where key in (1.2) to value" using the '=' as the 'IN' command database
3 Comments
Local Administrator
You can try using gold | (or) "selectdb sum(field) of "table" u_where (key = "1+|2") to value" or maybe "selectdb sum(field) of "table" u_where (key = $syntax("1+|2")) to value" failing that, it's back to go old OR. "selectdb sum(field) of "table" u_where ((key = 1 or key = 2)) to value"
Author: Iain Sharp (i.sharp@pcisystems.co.uk)
Local Administrator
I see no other option than: "selectdb sum(field) of "table" u_where (key = 1 | key = 2) to value" Maybe it would be nice to have the "where" clause available on the selectdb and not just the "u_where"
Author: Theo Neeskens (tneeskens@itblockz.nl)
Local Administrator
I already have used these ways, but when I have value in both, the command returns me only the value of one.
Author: IvanSantana (ivanandradesantana@gmail.com)