ComboStrap Analytics - How to query the analytics database
Table of Contents
1 - How-to
This page will show you how to query the analytics database online.
2 - Steps
2.1 - Go to the admin page
Click on the Admin link to go to the Admin Window. ie https://yourdomain.com/?do=admin
| ComboStrap Template | Dokuwiki Template |
|---|---|
 |  |
2.2 - Go to the Sqlite Interface
The SQLite interface is a webpage that permits to send statement to the SQLite database.
To access it directly, the URLis https://yourdomain.com/?do=admin&page=sqlite
2.3 - Choose the database
Choose the Combo database.
If you were users:
- of the 404Manager, the database may be named 404manager
- of the webcomponent plugin, the database may be named webcomponent
The URL to access your database will look like the following URL
https://yourdomain.com/?do=admin&page=sqlite&db=combo&version=sqlite3
2.4 - Enter your query and submit
Enter the analytical query and submit.
You can try the below query that returns statistics over words from the json analytics column.
select
count(*) as page_count,
round(avg(words)) as words_avg,
sum(words) as words_count,
max(words) as words_max,
min(words) as words_min
from
(
select
id,
json_extract(analytics , '$.statistics.words') as words
from
pages
where
analytics is not null
)
3 - Sqlite JSON Support
If it does not work, see the JSON support documentation on the data page