Query
Table of Contents
Classes
- Api4EntitySetQuery
- Constructs queries for set operations (UNION, etc).
- Api4Query
- A query `node` may be in one of three formats:
- Api4SelectQuery
- Constructs SELECT FROM queries for API4 GET actions.
- SqlBool
- Boolean sql expression
- SqlEquation
- Numeric sql expression
- SqlExpression
- Base class for SqlColumn, SqlString, SqlBool, and SqlFunction classes.
- SqlField
- Sql column expression
- SqlFunction
- Base class for all APIv4 Sql function definitions.
- SqlFunctionABS
- Sql function
- SqlFunctionAVG
- Sql function
- SqlFunctionBINARY
- Sql function
- SqlFunctionCOALESCE
- Sql function
- SqlFunctionCONCAT
- Sql function
- SqlFunctionCONCAT_WS
- Sql function
- SqlFunctionCOUNT
- Sql function
- SqlFunctionCURDATE
- Sql function
- SqlFunctionDATE
- Sql function
- SqlFunctionDATEDIFF
- Sql function
- SqlFunctionDAYOFWEEK
- Sql function
- SqlFunctionDAYSTOANNIV
- Sql function
- SqlFunctionEXTRACT
- Sql function
- SqlFunctionGREATEST
- Sql function
- SqlFunctionGROUP_CONCAT
- Sql function
- SqlFunctionGROUP_FIRST
- Sql function returns the first item in a GROUP_CONCAT set (per the ORDER_BY param)
- SqlFunctionIF
- Sql function
- SqlFunctionIFNULL
- Sql function
- SqlFunctionISNULL
- Sql function
- SqlFunctionLEAST
- Sql function
- SqlFunctionLEFT
- Sql function
- SqlFunctionLOWER
- Sql function
- SqlFunctionMAX
- Sql function
- SqlFunctionMIN
- Sql function
- SqlFunctionMONTH
- Sql function
- SqlFunctionNEXTANNIV
- Sql function
- SqlFunctionNOW
- Sql function
- SqlFunctionNULLIF
- Sql function
- SqlFunctionQUARTER
- Sql function
- SqlFunctionRAND
- Sql function
- SqlFunctionREPLACE
- Sql function
- SqlFunctionRIGHT
- Sql function
- SqlFunctionROUND
- Sql function
- SqlFunctionSUBSTRING
- Sql function
- SqlFunctionSUM
- Sql function
- SqlFunctionTIME
- Sql function
- SqlFunctionUPPER
- Sql function
- SqlFunctionYEAR
- Sql function
- SqlNull
- NULL sql expression
- SqlNumber
- Numeric sql expression
- SqlString
- String sql expression
- SqlWild
- Wild * sql expression