Custom SQL

Specifies an SQL statement to use to retrieve the records for a database-driven grid.

Promptable? YES
Possible Values: Any valid SQL statement*
Bindable? YES
Products: ProfoundUI, Genie

*The statement cannot end with a LIMIT clause. If the statement includes computed columns and filtering is enabled, then those columns must use aliases; otherwise, filtering will fail.

See the section, Filtering and Sorting Limitations with Custom SQL, in the page Database-driven Grids for more information about filtering Custom SQL grids.