My users have age and 3 columns for languages. How do I write “where clause” if I for example need users with age in some range and Spanish as one of three languages?
I tried
age>=minAge AND age<= maxAge AND (firstLanguage = ‘Spanish’ or secondLanguage = ‘Spanish’ or thirdLanguage = ‘Spanish’)
but it is incorrect. Age is ok, but the expression in () doesn’t work. How can I do it right?
What is your app ID and the name of the table?
01BBD038-838D-4A32-AF8E-122EB1D220C1
I am querying Users table.
400 - Where clause ‘cityId = ‘11D740DE-4657-40E1-86F8-E4297D5812C8’ AND sex = ‘Female’ AND age >= 25 AND age <= 35 AND objectId != ‘’ AND (nativeLanguage=‘Spanish’ OR secondLanguage=‘Spanish’ OR thirdLanguage=‘Spanish’’ is invalid (1017)
Ugh. Last ) missing. Working now.
you can combine all the individual text blocks to make it a bit more manageable and readable
1 Like