Load query in I5 Grid

[Former Member]

Hello Everyone,

I am trying to load following query in I5 Grid layout.But, its giving ORA00936 error as missing expression.

Please help me with this.

Query:

SELECT A.ID AS NAME,

REGEXP_SUBSTR (B.ORDER, '[^,]+', 1, 2) AS FIRST_ORDER,

REGEXP_SUBSTR (B.ITEM, '[^,]+', 1, 2) AS MATERIAL,

(CASE WHEN COUNT(CASE WHEN C.STATE = 'O' THEN 1 ELSE null END)>0 THEN 'OPEN' ELSE 'CLOSED'  END) AS COUNT,

FROM A

LEFT JOIN B

ON A.ID= B.NAME

FULL OUTER JOIN C

ON SUBSTR(C.NC_CONTEXT_GBO,12)=A.ID

where A.ID IN ([Param.1])

group by A.ID, B.ORDER,B.ITEM

[swaroop_anasane]

Hi Deepali,

I second Sai for his observation, remove comma.

If you get "ORA00936 error as missing expression", it's a syntax error. Check through your query once again and sanitize.

Regards,

Swaroop

[saivellanki]

Hi Deepali,

Try removing comma after COUNT and check?

Also if Param.1 is a string, then change it to where A.ID IN ('[Param.1]')

Regards,

Sai Vellanki.