The SQL statement for a query begins with SELECT This, followed by the SQL commands for column definitions and search criteria. If the SQL statement includes a JOIN clause, the reference to This must be fully qualified with a table name, such as CustomObject.This.
Here are some examples of different types of syntax:
A simple query |
|
---|---|
A table join (to find unfiled custom objects) |
|
Date comparisons |
|
Custom search functions | In the following example, the custom search function is
CmRpt::FormatDate. For information about search functions, see Creating custom search functions.
![]()
![]() |