Stable version 1.0.1 (Compatible with OutSystems 11)

Uploaded

on 03 December 2021

5.0

(1 rating)

Details

The Extensible Reports application enhances Service Center Analytics by offering insights into report generation. It allows developers to create custom reports, automate them to run periodically, and extend features to meet specific needs.

The Extensible Reports application is based on the existing reports functionality from Service Center Analytics. The goal of this application is to provide insight into how Service Center Reports are done, and provide a way for developers to extend this feature by creating new reports, having them run periodically without human intervention, or other use cases which will be useful for your individual needs.

You can find detailed information and instructions on how to use and edit this component here.

Release notes (1.0.1)

Fixed a bug reported by Leanderson Monteiro where parsing SLOWSQL could return an error.

License (1.0.1)

BSD-3 license (https://opensource.org/licenses/BSD-3-Clause)

Reviews (1)

2021-10-29

in version 1.0.0

Hello guys,

Great component, To generate SQL Slow report, I saw some erros with SQL Server, not generate the report, in CAST to Integer.

In my case, I do this :
CAST(
            SUBSTRING(
                Message,
                PATINDEX('% took %', Message) + 6,
                IIF(((LEN(SUBSTRING(Message, CHARINDEX('took ', Message), LEN(Message))) - LEN(SUBSTRING(Message, CHARINDEX(' ms', Message), LEN(Message)))) - 5) < 0, 0, ((LEN(SUBSTRING(Message, CHARINDEX('took ', Message), LEN(Message))) - LEN(SUBSTRING(Message, CHARINDEX(' ms', Message), LEN(Message)))) - 5))
            ) AS INTEGER
        ) AS Duration

Some times I dont receive numbers or don't get only numbers.

with this change on Query to SQL Server, my problem got solved.

Congrats.

Team