Question
Issues with Export SQL To Excel Smart Service
We are trying to get an excel document from a SQL Query and we are getting the following error:
| Export SQL To Excel | An error occurred in executing an Activity Class. |
We tried to rewrite the SQL sentences using quotes but it keeps failing the same way.
SQL Sentence:
SELECT
`ORDER_BY` AS `EMPLEADO`,
`PLATO`,
`IS_PAN` AS `PAN`
FROM
`SL_ORDERS`
INNER JOIN `SL_LUNCH` ON `SL_ORDERS`.`LUNCH_ID`=`SL_LUNCH`.`ID`
WHERE
`SL_ORDERS`.`ID` IN ('1', '2')
AND `SL_ORDERS`.`DIA_SEMANA`='1'
We know the problem is from the SQL sentence because if we put a typical Select * table without anything else works, so everything else is fine in the input section.