'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

3 Comments

  1. 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)
  2. 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)
  3. 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)