Class Any

Namespace

YndigoBlue.Velocity.Functions

Assembly

YndigoBlue.Velocity.dll

Represents the ANY quantified comparison operator that tests if any value in a subquery satisfies a condition.

public class Any : Function, ICheckItem, IDefaultItem, IFilterItem, IElement

Inheritance

object

Function

Any

Implements

ICheckItem

IDefaultItem

IFilterItem

IElement

Remarks

The ANY operator is used with a comparison operator (=, <, >, etc.) to test if the condition is true for at least one value returned by a subquery. For example, "value > ANY (subquery)" returns true if value is greater than at least one value in the subquery result. This is useful for conditional filtering based on subquery results, set membership tests, and complex WHERE clause conditions.

Examples

Find customers who have placed at least one high-value order:

var schema = manager.LoadSchema("sales");
var customers = schema["customers"];
var orders = schema["orders"];

var subQuery = new Query()
    .Select([ orders["customer_id"] ])
    .From(orders)
    .Where(new Criterion<decimal>(orders["amount"], ConditionalType.GreaterThan, 1000m));

var query = new Query()
    .Select([ customers["id"], customers["name"] ])
    .From(customers)
    .Where(new Criterion<Expression>(customers["id"], ConditionalType.Equals, new Expression(new Any(subQuery))));

var results = manager.Retrieve(query);

Constructors

Any(IEnumerable<IElement>)

Initializes a new instance of ANY for multiple elements.

Any(IElement)

Initializes a new instance of ANY for a single element.