Hello team,

We changed from version 9416 to 11306 (some time ago).

There are some SQL reports that we cannot create because there are some things in the query that are not allowed now.

This line is falling (into the SELECT):

(ROUND(((WorkOrder.timespentonreq/1000)/3600),2))||':'||(ROUND((((WorkOrder.timespentonreq/1000)/60)) % 60,2)) "Tiempo transcurrido(Creacion - Resolucion)",

The problem is the connector   ||':'||. I cannot fix it. We tried with CONCAT ((....),':',(....)) AS... but didn't work.

do you know how to use "||" in version 11.3?

Thank you very much!!

Best regards,

David Gallardo