extensible-reports
Web icon

Extensible Reports

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

Extensible Reports

5 star
1
1 Review |  1 Rating
4 star
0
0 Reviews |  0 Ratings
3 star
0
0 Reviews |  0 Ratings
2 star
0
0 Reviews |  0 Ratings
1 star
0
0 Reviews |  0 Ratings
1
Rating
5.0
1
Review
by 
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.