mercredi 16 octobre 2019

Lavacharts Eloquent Query

I need assistance with using LavaCharts, has anyone used it to get data from multiple tables?

I want to get a report showing count of cities in a particular province.

The cities table has a province_id, so I want to show a geo chart by province with number of cities in that province.

This is the raw sql query that gives me the data from db

SELECT
provinces.`name`,
Count(cities.province_id)
FROM
cities ,
provinces
WHERE
cities.province_id = provinces.id
GROUP BY
provinces.`name`


via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire