Hello:
I need to limit filter results to 500 rows - I have tried using the prefilters by adding queries like:
Field: plant_id (=PK)
Condition: In
Value: SELECT `plant_id` FROM `dws_plantsb` WHERE `published` = 1 GROUP BY `common_name` LIMIT 0, 500
So far, this throws a Mysql error: This version of MariaDB doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery, etc.
Adding LIMIT to the end of a prefilter subquery does not throw an error - but the query simply ignores it.
This thread has a suggested edit for a prefilter with LIMIT:
http://fabrikar.com/forums/index.php?threads/list-filtered-by-element.43734/#post-223839
I've been trying to adapt the suggestion without success.
If there is a way to add LIMIT to filters directly, I'd love to hear.
Thank you!
-Alan
I need to limit filter results to 500 rows - I have tried using the prefilters by adding queries like:
Field: plant_id (=PK)
Condition: In
Value: SELECT `plant_id` FROM `dws_plantsb` WHERE `published` = 1 GROUP BY `common_name` LIMIT 0, 500
So far, this throws a Mysql error: This version of MariaDB doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery, etc.
Adding LIMIT to the end of a prefilter subquery does not throw an error - but the query simply ignores it.
This thread has a suggested edit for a prefilter with LIMIT:
http://fabrikar.com/forums/index.php?threads/list-filtered-by-element.43734/#post-223839
I've been trying to adapt the suggestion without success.
If there is a way to add LIMIT to filters directly, I'd love to hear.
Thank you!
-Alan