In the "Query Builder" I can currently filter on value from the "Values List", but I'd like to be able to filter for multiple values at once.
How can I go about doing this using the SQL and "Operator's Section"?
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.
Sign up to join this communityOne method is to use the IN
function followed by your list of values all inside brackets.
E.g.
"Column_Name" IN ('Value_1', 'Value_2', 'Value_N')
Hope this helps!
The alternative is to use an AND/OR statement:
"Column_Name" = 'Value_1' OR "Column_Name" = 'Value_2'