Salesforce

Magic xpa SQL Functions (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Magic xpa SQL Functions (Magic xpa 4.x)

Magic xpa SQL is similar to the SQL Where Range. Unlike the SQL Where Range, which can use any free form text, the Magic xpa SQL Where range is limited to expressions that the Magic xpa engine can translate to SQL.

The following expressions can be used in a Magic xpa SQL Where Range:

Character functions

Len
Lower

Upper

LTrim

RTrim

Trim

MID

InStr
**
&
IN

Date functions

Date
Time
AddDate

AddTime

Year

Month

Day

Hour

Minute

Second

Str

Val

Arithmetic operators

Addition (+)
Subtraction (-)
Multiplication (*)
Division (/)

Logical operators

OR
AND
NOT

Comparison operators

Equal To (=)
Less Than (<)
Less Than or Equal To (<=)
Greater Than (>)
Greater Than or Equal To (>=)
Different Than (<>)
LIKE

NULL functions

NULL
ISNULL

Arithmetic functions

ABS
MOD
LOG

EXP

Round

Trigonometric functions

SIN
ASIN

CO
S
ACOS

TAN

ATAN

Convert functions

ASCIIChr***
ASCIIVal
DStr

TStr

**Cannot be used in the Magic xpa SQL Where Range if the database is SQLite.

***Not supported when used in the Magic xpa SQL Where if the database is SQLite.

Reference
Attachment 
Attachment