tabix icon indicating copy to clipboard operation
tabix copied to clipboard

Documentation: More variable examples

Open mlibbey opened this issue 2 years ago • 0 comments

I've been trying to figure out how to use a variable when quoting is needed for instance, if the query has something like where date >= ('2022-12-01') and I set a variable start to be 2022-12-01 and tried things like where date >= ($start) where date >= ('$start') where date >= ("$start") where date >= ('$start') where date >= ('$start')

Eventually realized that the variable should have the quoting inside it: start '2022-12-01'

Guess my suggestion would be on https://tabix.io/doc/Tips/#variables to say If you want your variable to be inside quotes in the query, please include the quotes in the variable. For instance, setting the start variable to '2022-12-01' and using it in the query like where date >= ($start) will result in where date >= ('2022-12-01') being sent to the server.

mlibbey avatar Dec 11 '22 00:12 mlibbey