Named query with or without ";" at the end

Ignition
1

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

image
v
v
image

In case is useful for someone

2
  1. You might mention which database engine you are using. MySQL, MS SQL, etc.
  2. Was there an error message?
  1. I've never seen WHERE with no operator (=, !=, <, >). Where did you find that syntax?
3

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

4

That's new to me. I've never used Oracle.

Anyone else? What's happening here. Is WHERE just looking for non NULLs?

5

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."

6

Could you provide the whole code?

7

ok, i think there is no issue, it´s an Oracle thing, previous code was without ";"