ArxConditionOperator enum · MongoDB in C#

Definition

Namespace: ARX.SDK.Query
Package: ARX.SDK

public enum ArxConditionOperator

How a condition compares its attribute with its values. Contains, BeginsWith and EndsWith (and their negations) treat % and _ as plain characters. Whether they ignore case depends on the database: PostgreSQL and MongoDB ignore it; on SQL Server and MySQL the column's collation decides (the default ignores it; a binary or case-sensitive collation such as utf8mb4_bin doesn't); DynamoDB compares case-sensitively and only when asked (CaseSensitivePatterns).

Values

Equal= 0: The attribute equals the value.
NotEqual= 1: The attribute differs from the value; never matches a null or a missing attribute.
GreaterThan= 2: The attribute is greater than the value.
LessThan= 3: The attribute is less than the value.
GreaterEqual= 4: The attribute is greater than or equal to the value.
LessEqual= 5: The attribute is less than or equal to the value.
Like= 6: The attribute matches a pattern (% any text, _ one character); where a provider can't, ARX8001.
NotLike= 7: The attribute doesn't match the pattern.
In= 8: The attribute equals one of the values.
NotIn= 9: The attribute equals none of the values.
Between= 10: The attribute is between the two values, both included.
NotBetween= 11: The attribute is outside the two values.
Null= 12: The attribute is null (or, where documents may omit it, missing).
NotNull= 13: The attribute has a value.
Contains= 49: The attribute contains the text (the value is text, never a pattern).
DoesNotContain= 50: The attribute doesn't contain the text.
BeginsWith= 54: The attribute begins with the text.
DoesNotBeginWith= 55: The attribute doesn't begin with the text.
EndsWith= 56: The attribute ends with the text.
DoesNotEndWith= 57: The attribute doesn't end with the text.

Usage

A line from a verified sample; the full, runnable code is on its page.

query.Criteria.AddCondition("order_total", ArxConditionOperator.GreaterThan, 50m);

Use fields named outside the name rule, through aliases, scenario 2

Used in:

Use fields named outside the name rule, through aliasesCreate
Log every call through ILoggerCreate
Update or delete every document a filter matchesUpdateMultiple
Read many recordsRetrieveMultiple
Page through resultsRetrieveMultiple
Read an account with its contactsRetrieveMultiple
A report by industryRetrieveMultiple
Catch an injection attemptRetrieveMultiple
Read your writes in a transactionRetrieveMultiple
A security check around a search endpointRetrieveMultiple
Set up the service from the database's schemaRetrieveMultiple
Protect paging cookiesRetrieveMultiple