Create a ViewTool to retrieve the CA data

[freddyDOTCMS]

Parent Issue

#29477

User Story

We need to create a ViewTool to retrieve CA data. This ViewTool will allow us to run a query directly on the CA data. To do this, we'll create a ViewTool that utilizes the utility method created here #29865

Acceptance Criteria

New ViewToll be ready to use

Proposed Objective

Core Features

Proposed Priority

Please Select

External Links... Slack Conversations, Support Tickets, Figma Designs, etc.

No response

Assumptions & Initiation Needs

No response

Quality Assurance Notes & Workarounds

No response

Sub-Tasks & Estimates

No response

[freddyDOTCMS]

Pass IQA: Work as expected even when we have some point to improve in the Query syntax the ViewTool is working well

Improvement we need in the query syntax:

• Support Or logic operator in CA Query filters #30190
• Support filters arrays multi values in the CA Query #30191

[freddyDOTCMS]

Note to QA: Go to the Dev Tools > Velocity portlet and test with code like this:

#set ($queryMap = {"measures" : ["request.count"], 
                "orders": "request.count desc",
                "dimensions":["request.url", "request.pageId","request.pageTitle"],
                "filters":"request.whatAmI = ['PAGE']"
                })

#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