Allow Any Select Statement



Allows any valid SELECT SQL statement. If this isĀ falseĀ (default), a row count is retrieved by running SELECT COUNT(* ) FROM (your-custom-sql-property), so your "custom sql" property must work with that syntax. This prevents the use of common table expressions, the optimize clause, and a few other things. If set to true, the row count will be determined by running Ā your statement as-is and looping through all rows to count them.

Note:Ā False performs better, but true allows a wider variety of SQL statements.

Promptable?Ā DROPDOWN
Possible Values:Ā true, false
Bindable?Ā YES
Products:Ā ProfoundUI, Genie