ShopifyQL - How to concatenate strings?

Highlighted
Shopify Partner
107 2 14

How do we concatenate strings together in ShopifyQL?

Consider the following query, which doesn't make sense but this is just an example:

SHOW count(DISTINCT session_token)
BY 'a' + 'b'
FROM visits
SINCE -2m UNTIL -1d

Result:

{"query":null,"message":"validation error [0,0]: can't add string and string","tag":"parse","code":0,"params":null}

 

Also, how do we convert a number to a string?

0 Likes