Allow Any Select Statement

Owned by Former user (Deleted)
Last updated: Aug 16, 2023 by Jessica Tomkins
1 min read



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