MigsLab MySQL · Types · Queries
ArxConditionOperator
Definition
- Namespace
ARX.SDK.Query- Package
ARX.SDK
public enum ArxConditionOperatorHow 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= 0The attribute equals the value.
NotEqual= 1The attribute differs from the value; never matches a null or a missing attribute.
GreaterThan= 2The attribute is greater than the value.
LessThan= 3The attribute is less than the value.
GreaterEqual= 4The attribute is greater than or equal to the value.
LessEqual= 5The attribute is less than or equal to the value.
Like= 6The attribute matches a pattern (
%any text,_one character); where a provider can't, ARX8001.NotLike= 7The attribute doesn't match the pattern.
In= 8The attribute equals one of the values.
NotIn= 9The attribute equals none of the values.
Between= 10The attribute is between the two values, both included.
NotBetween= 11The attribute is outside the two values.
Null= 12The attribute is null (or, where documents may omit it, missing).
NotNull= 13The attribute has a value.
Contains= 49The attribute contains the text (the value is text, never a pattern).
DoesNotContain= 50The attribute doesn't contain the text.
BeginsWith= 54The attribute begins with the text.
DoesNotBeginWith= 55The attribute doesn't begin with the text.
EndsWith= 56The attribute ends with the text.
DoesNotEndWith= 57The 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 columns named outside the name rule, through aliases, scenario 2
Used in:
- Use columns named outside the name rule, through aliasesCreate
- Log every call through ILoggerCreate
- Update every row a filter matchesUpdateMultiple
- Delete every row a filter matchesDeleteMultiple
- Read your own writes in an ARX transactionRetrieve
- Retrieve many records with a queryRetrieveMultiple
- Page through resultsRetrieveMultiple
- Query without a catalogRetrieveMultiple
- A contact search screenRetrieveMultiple
- Accounts and contacts in one queryRetrieveMultiple
- A report: accounts by industryRetrieveMultiple
- Dates and times in conditionsRetrieveMultiple
- Read a viewRetrieveMultiple
- Rows from a function: refused on MySQL, and what to read insteadRetrieveMultiple
- Lookups and display namesRetrieveMultiple
- Turn read errors into messagesRetrieveMultiple
- Catch an SQL injection attempt on a searchRetrieveMultiple
- Read in a batch scopeRetrieveMultiple
- Export a large table in pagesRetrieveMultiple
- A security check around a search endpointRetrieveMultiple
- Filter expressions in depth: nesting, recursion, links, And and OrRetrieveMultiple
- Link entities in depth: chains, branches, criteria per level, recursionRetrieveMultiple
- Paging in depth: the total is opt-in, ask once, load more, Top, seek pagingRetrieveMultiple
- Read other row sources: a view in a schema, a summary view, a table with no idRetrieveMultiple
- Functions in depth on MySQL: tables, procedures and scalar values instead of row sourcesRetrieveMultiple
- Views in depth: computed criteria, links both ways, declared ids and lookups, column boundariesRetrieveMultiple
- Retrieve on a preloaded schema: lookups found, column types, Strict, saved JSONRetrieveMultiple
- Page through a procedure's result: the procedure pages itself, ARX pages a result setExecute
- Execute on a preloaded, Strict schema: routines aren't covered, tables areExecute