Page History
...
Where 1 signifies the primary/default organization.
Disable row limit on filtered queries
Yellowfin restricts the number of rows returned from queries that involve filter values. This is the same limit that is applied for all database queries (i.e. even those without any filters) and is configurable by the user in the View builder and at the Report level. However, there is a hidden configuration that allows users to remove this limit from filtered queries, thereby allowing Yellowfin to return all matching rows. To apply this, add the following SQL into your Configuration database:
Warning: Be careful when disabling the limit. If the filtered query returns a large amount of values, it might result in a system hang up.
Code Block |
---|
INSERT INTO Configuration Values (1, 'SYSTEM', 'DISABLEFILTERPROMPTLIMIT', 'TRUE'); |