Where

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.