MigsLab MySQL · Types · Queries
ArxJoinOperator
Definition
- Namespace
ARX.SDK.Query- Package
ARX.SDK
public enum ArxJoinOperatorThe join a link entity makes: Inner, Left or Right. Default joins as Inner. (Named INNER, LEFT, RIGHT and DEFAULT before 1.0.0-rc.1.)
Values
DefaultNo join kind given: an inner join.
InnerOnly rows that have a match in the linked table.
LeftEvery row of the query's table, with the linked table's columns null where nothing matches.
RightEvery row of the linked table, with the query's columns null where nothing matches (not on MongoDB).
Usage
A line from a verified sample; the full, runnable code is on its page.
var account = query.AddLink("account", "account_id", "id", ArxJoinOperator.Inner);Accounts and contacts in one query, scenario 1
Used in:
- Accounts and contacts in one queryRetrieveMultiple
- Filter expressions in depth: nesting, recursion, links, And and OrRetrieveMultiple
- Link entities in depth: chains, branches, criteria per level, recursionRetrieveMultiple
- 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