I have created a MySQL view using the below query:
SELECT Suburb, Year, SUM(IncidentsRecorded), COUNT(IncidentsRecorded) FROM fabrik_crime
GROUP BY Year, Suburb
What is the best way to create a list from this? Obviously it will be a read only list that needs to be searched. Is there any way this is possible?
I keep on getting error 500 everytime I try it. I have set "Alter field types" to No and added an internal id field ID and no luck.
SELECT Suburb, Year, SUM(IncidentsRecorded), COUNT(IncidentsRecorded) FROM fabrik_crime
GROUP BY Year, Suburb
What is the best way to create a list from this? Obviously it will be a read only list that needs to be searched. Is there any way this is possible?
I keep on getting error 500 everytime I try it. I have set "Alter field types" to No and added an internal id field ID and no luck.