Present the variety of person accounts created inside a date vary. Date vary choice is uncovered to the customer.
Try with views
With views, we get the uncovered filters without spending a dime and needn’t write our personal customized type and question.
There are two ways in which views may very well be used for this:
- Present a single row with
- Present a header with the entire depend, then disguise all of the rows.
Each of those methods have issues:
- Displaying a single row with
COUNTwon’t work with MySQL 5.7+: https://www.percona.com/weblog/2019/05/13/solve-query-failures-regarding-only_full_group_by-sql-mode/ as a result of views will all the time add the uid column which isn’t distinctive throughout the grouping (by including a
COUNT, the grouping is all rows implicitly).
- We didn’t discover any views plugin that might disguise the rows. It may be finished with templates or (god forbid) CSS, however ideally there can be an answer with out customized code.
Is there a views plugin or another resolution on the market in contrib of any sort that can disguise all rows, in order that solely the header is proven?
- pager plugin to indicate zero rows
- row or type plugin to print nothing.
- show sort plugin to not present any rows.