Open freddyDOTCMS opened 1 week ago
Passed Internal QA:
Tested with this query in the velocity query tool:
#set ($queryMap = {"measures" : ["request.count"],
"orders": "request.count desc",
"dimensions": [
"request.url",
"request.pageTitle",
"request.fileTitle",
"request.whatAmI",
"request.pageId"
],
"filters":"request.whatAmI = ['PAGE', 'FILE']"
})
#set($collection = $analytics.runReportFromMap($queryMap).getResults())
Accessed Pages
#foreach($item in $collection)
-> What I am: $item.get("request.whatAmI").get()
#if($item.get("request.whatAmI").get()=="FILE")
-> File Title: $item.get("request.fileTitle").get()
#else
-> Page Title: $item.get("request.pageTitle").get()
#end
-> Page URL: $item.get("request.url").get()
-> Page Count: $item.get("request.count").get()
#end
Response as expected https://gist.github.com/dsilvam/96062619fe6baad731d9d91173d284e5
Approved: Tested on trunk_a12617a, Docker, macOS 14.5, FF v126.0.1
Parent Issue
30141
Problem Statement
We create a new query sintax for the CA Endpoint and ViewTool, is not really the same CubeJs syntax, let see an example on the filter attribute:
Example to get All the FILE and PAGE request:
CubeJS Query:
Our less verbose Syntax:
This is not working because it ignore the FILE value
Steps to Reproduce
Start dotCMS with the full starter
Start Analytics to this just: Go to ""/core/docker/docker-compose-examples/analytics"" and run the command "docker-compose up", and wait a couple of minutes, Configure the Analitycs App in dotCMS with the follow parameters:
Navigate in the dotCMS FE to the Home Page this is going to include request to '/dA/716dcfa9-537d-419a-837f-73084a499cf3/fileAsset/1200w/50q/bg-footer.jpg'.
GO to the Velocity playground and run this code
set($collection = $analytics.runReportFromMap($queryMap).getResults())
Accessed Pages
foreach($item in $collection)
-> Page Title: $item.get("request.pageTitle").get() -> Page URL: $item.get("request.url").get() -> Page ID: $item.get("request.pageId").get() -> Page Count: $item.get("request.count").get()
end