103 Posts
7 years ago
2
Topic
Hi Friends!
Can we create a search and list based on a MySql View?
Best Regards.
4229 Posts
7 years ago
1
Level 1
Probably you could use them in search query plugin that allows custom queries to be performed and their results to be used in list.
103 Posts
7 years ago
0
Level 2
Actually I have a simple list with 2 columns like:
| City | Name |
| Raipur | Shubhaanshu |
| Jagdalpur | Ramesh |
|
Delhi
|
Akash |
| Raipur | Suresh |
| Raipur | neeraj |
| Jagdalpur | Sakesh |
| Jagdalpur | Amit |
| Raipur | Narayan |
| Delhi | Abhay |
I want to count the records grouped by city
| City(grouped) | Name (count) |
| Raipur | 4 |
| Jagdalpur | 3 |
|
Delhi
|
2 |
I am using the Chart template and need this to show the chart dynamically