The WHERE keyword filters a list or concept set.
This function is SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a filtered list or concept set.
list where condition
[Products.Name] of [Products] WHERE [Products.Price] > 100 => the names of all products that have a price higher than 100.
concept_set where condition
GetChildren('Color') WHERE concept:'PrimaryColor' = true => all color concepts from the Color collection that have the PrimaryColor property set to true.
Last modified 1yr ago