[Logs Management] Error in Advanced Query

[Logs Management] Error in Advanced Query

  
Forge Component
(4)
Published on 11 May by Carlos Alfaro
4 votes
Published on 11 May 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.