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.