Allowed Built-In SQL Functions

FogBugz Plugin API > Generic Database Access  > Allowed Built-In SQL Functions

The following built-in SQL functions are allowed in CQuery clauses because they are demonstrated to work identically across all supported database platforms:

This list is not necessarily exhaustive.  

Aggregators

These functions are aggregator functions, and are valid in SELECT and ORDER BY clauses.  They allow a single parameter (e.g. COUNT(ixBug)) , or the special parameter "*" (e.g. COUNT(*)).

• AVG
• COUNT
• MAX
• MIN
• SUM

Single-Parameter Functions

These functions take a single parameter.

• ABS
• COS
• SIN
• TAN
• EXP
• LOG
• LTRIM
• RTRIM
• SPACE
• YEAR
• MONTH
• DAY

Double-Parameter Functions

These functions take two parameters.

• ROUND
• LEFT
• RIGHT

Triple-Parameter Functions

• REPLACE