extensible-reports
Web icon

Extensible Reports

Stable version 1.0.1 (Compatible with OutSystems 11)
Published on 03 December 2021 by 
5.0
 (1 rating)
extensible-reports

Extensible Reports

Details
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.
Read more

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

What’s new (1.0.1)

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

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.
Related assets
More from Vanguard Labs