Custom SQL

Owned by Brian May
Last updated: Aug 16, 2023 by Jessica Tomkins
1 min read



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.