Training
Training
Welcome
Guided Paths
Build an App
Training Planner
Courses
Developer Schools
Boot Camps
Certifications
Tech Talks
Documentation
Documentation
Overview
ODC
O11
Forums
Forge
Get Involved
Get Involved
Home
Jobs
Ideas
Members
Mentorship
User Groups
Downloads
Platforms
OutSystems.com
My Platform
Community
Resources
Support
Search in OutSystems
Log in
Sign Up
Community
›
Forge
›
Assets list
›
Extensible Reports
Extensible Reports
Stable version
1.0.1
(Compatible with
OutSystems 11
)
Uploaded
on
03 December 2021
by
5.0
(1 rating)
Overview
Reviews
Versions
Documentation
Support
Extensible Reports
Reviews
Sort by:
Newest
Newest
Oldest
Highest rating
Lowest rating
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.
Loading...
Loading