[Logs Management] Error in Advanced Query

[Logs Management] Error in Advanced Query

  
Forge Component
(5)
Published on 2016-11-28 by Carlos Alfaro
5 votes
Published on 2016-11-28 by Carlos 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... 
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
Concat wasn't built in in SQL Server until recently. 2012 mybe.
You can always concatenate with the plus sign.