report_technologies
2 rows where report_id = "8a24fb67-2b38-469b-b6d8-48b5a2b8916e"
This data as json, CSV (advanced)
| Link | report_id | name | type | source |
|---|---|---|---|---|
| 8a24fb67-2b38-469b-b6d8-48b5a2b8916e,Matomo,runtime | https://webbutbildning.mcf.se/utb/EM-hot/ 8a24fb67-2b38-469b-b6d8-48b5a2b8916e | Matomo | analytics | runtime |
| 8a24fb67-2b38-469b-b6d8-48b5a2b8916e,Matomo Tag Manager,runtime | https://webbutbildning.mcf.se/utb/EM-hot/ 8a24fb67-2b38-469b-b6d8-48b5a2b8916e | Matomo Tag Manager | analytics | runtime |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE report_technologies ( report_id TEXT NOT NULL REFERENCES reports(id) ON DELETE CASCADE, name TEXT NOT NULL, type TEXT NOT NULL, source TEXT NOT NULL, PRIMARY KEY (report_id, name, source) ); CREATE INDEX idx_report_technologies_name ON report_technologies(name);