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
Some documentation pages have recently moved to a new section: Profound AppDev. If you are having trouble finding specific pages, try the documentation search capability or reach out to our Support team!