ArxOrderType

Definition

Namespace

ARX.SDK.Query

Package

ARX.SDK

public enum ArxOrderType

Values

Ascending= 0

Smallest first.

Descending= 1

Largest first.

Usage

query.AddOrder("first_name", ArxOrderType.Descending);

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

Used in:

• Use columns named outside the name rule, through aliasesCreate
• 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
• Rows from a function: refused on MySQL, and what to read insteadRetrieveMultiple
• Catch an SQL injection attempt on a searchRetrieveMultiple
• 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
• Page through a procedure's result: the procedure pages itself, ARX pages a result setExecute