Skip to Content (Press Enter)
2015-04-07 15-19-51
Braxton
104Views
2Comments
[Logs Management] Error in Advanced Query
Question
Forge
logs-management
Web icon
Logs Management (O11)
Forge asset by Alfaro
Running on MS SQL on Win 2k8 IIS7 Outsystems Version 9.1.0.20.


Error in advanced query GetLogTableTypeColors in Preparation in Dashboard in MainFlow in LogsManagement (SELECT {LogTableType}.[Label],      CONCAT('{color: ''', CONCAT({LogTableType}.[Color], '''}'))  FROM {LogTableType}  ORDER BY {LogTableType}.[Order]): 'CONCAT' is not a recognized built-in function name.


This is a clean fresh install of Logs Management... 
0
0
26 Apr 2016
Copy Link
2025-02-22 18-27-01
Alfaro
 
MVP
Hello,

Can you tell me the version of your MS SQL Server?
As far as I can tell, the CONCAT function is built-in - CONCAT (Transact-SQL).

Thank you.

C. Alfaro
0
0
26 Apr 2016
Copy Link
2016-04-22 00-29-45
Nuno Reis
 
MVP
Concat wasn't built in in SQL Server until recently. 2012 mybe.
You can always concatenate with the plus sign.
0
0
27 Apr 2016
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.