103 Posts
shubhaanshu
4 years ago
2
Topic

Hi Friends!

Can we create a search and list based on a MySql View?

Best Regards.

Get a VIP membership
4229 Posts
Kadministrator
4 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
shubhaanshu
4 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

Get a VIP membership