Welcome, Guest
Username: Password: Remember me
here you can submit any topics related ExtraWatch

TOPIC: Mysql query for Extrawatch Pro Heatmap

Mysql query for Extrawatch Pro Heatmap 1 year 11 months ago #519

My goal is to generate a monthly report of the heatmap. But it seems you don't have any export facility for a report. Can you at least help me with the mysql query you used for the Heatmaps?

With the columns - Clicks , Title, Uri

All-time clicks

To see the heatmap, just click on some of the links in the table
The administrator has disabled public write access.

Mysql query for Extrawatch Pro Heatmap 1 year 11 months ago #531

SELECT * , count( uri2TitleId ) AS `count` FROM `#__extrawatch_heatmap`
JOIN `#__extrawatch_uri2title` ON #__extrawatch_heatmap.uri2titleId = #__extrawatch_uri2title.id GROUP BY uri2TitleId
ORDER BY `count` DESC
The administrator has disabled public write access.

Mysql query for Extrawatch Pro Heatmap 1 year 11 months ago #532

Please give us example of such report then so that we might include it to the next version
The administrator has disabled public write access.
Time to create page: 0.113 seconds
Joomla SEF URLs by Artio
X

Drop us your message