I notice when I write my query with ";" at the end it doesn´t show data, when i write it without the ";" it works.
SELECT DISTINCT
Asset.asset AS "Activo",
....
FROM
Asset
LEFT JOIN ...EquipmentType.EquipmentType
LEFT JOIN ....
WHERE
Asset.compan...
CASE
WHEN SubStr(Asset.businessUnit, 1, 3) IN ('CAT', 'BAL', 'MUR', 'VAL', 'AND', ....
END,
Asset.businessUnit,
Asset.parentAsset,
Asset.asset
![image](https://global.discourse-cdn.com/inductiveautomation/original/3X/c/4/c406a95d2cf4d8e9c20465d400c0690dc997945b.png)
![image](https://global.discourse-cdn.com/inductiveautomation/original/3X/7/b/7b0091c3d89d2b33ee211a636a694aabccb1b8d7.png)
v
v
![image](https://global.discourse-cdn.com/inductiveautomation/original/3X/9/e/9ecb328d945340c5218e610c42100bc43bed3ba8.png)
In case is useful for someone
It´s Oracle Query,
happens when I try to adapt the queryes from Ignition Vision to named queries in Ignition Perspective. That syntax I got from the previous project
![image](https://global.discourse-cdn.com/inductiveautomation/original/3X/1/a/1adf794cf6efa47935f33dae8e19e5f97bba9a7d.png)
That's new to me. I've never used Oracle.
Anyone else? What's happening here. Is WHERE just looking for non NULLs?
This is the error:
Subcode
Error_Exception
Property
root/TabContainer/TablaInventario.data
Description
java.sql.SQLSyntaxErrorException: ORA-00907: falta el paréntesis derecho
tranlation "the right parenthesis is missing."
Could you provide the whole code?
ok, i think there is no issue, it´s an Oracle thing, previous code was without ";"