I need to create prompt in OTBI with Aging days having case function defined, when running i am getting the below error, can someone help me on this
CASEWHEN Timestampdiff(sql_tsi_day,"Shipping Real Time"."- Shipment Details"."WSH_NEW_DELIVERIES_A3PL_NTRFC_TNSTNP_",current_date) <= 5 THEN '1-5 'WHEN Timestampdiff(sql_tsi_day,"Shipping Real Time"."- Shipment Details"."WSH_NEW_DELIVERIES_A3PL_NTRFC_TNSTNP_",current_date) BETWEEN 6 AND 15 THEN '6-15'WHEN Timestampdiff(sql_tsi_day,"Shipping Real Time"."- Shipment Details"."WSH_NEW_DELIVERIES_A3PL_NTRFC_TNSTNP_",current_date) BETWEEN 16 AND 30 THEN '16-30'WHEN Timestampdiff(sql_tsi_day,"Shipping Real Time"."- Shipment Details"."WSH_NEW_DELIVERIES_A3PL_NTRFC_TNSTNP_",current_date) > 30 THEN '> 30'ELSE 'NA'END
Error Codes: OAMP2OPY:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P:OI2DL65PError during query processing (SQLExecDirectW).State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)State: HY000. Code: 27002. [nQSError: 27002] Near <WHEN>: Syntax error (HY000)State: HY000. Code: 26012. [nQSError: 26012] . (HY000)SQL Issued: {call NQSGetQueryColumnInfo('SELECT "Shipping Real Time".CASE WHEN Timestampdiff(sql_tsi_day,"- Shipment Details"."WSH_NEW_DELIVERIES_A3PL_NTRFC_TNSTNP_",current_date)<=5 THEN ''1-5 '' WHEN Timestampdiff(sql_tsi_day,"- Shipment Details"."WSH_NEW_DELIVERIES_A3PL_NTRFC_TNSTNP_",current_date) BETWEEN 6 AND 15 THEN ''6-15'' WHEN Timestampdiff(sql_tsi_day,"- Shipment Details"."WSH_NEW_DELIVERIES_A3PL_NTRFC_TNSTNP_",current_date) BETWEEN 16 AND 30 THEN ''16-30'' WHEN Timestampdiff(sql_tsi_day,"- Shipment Details"."WSH_NEW_DELIVERIES_A3PL_NTRFC_TNSTNP_",current_date)>30 THEN ''> 30'' ELSE ''NA'' END FROM "Distributed Order Orchestration - Fulfillment Lines Real Time"', 'PRECISION_SCALE')}SQL Issued: SELECT "Shipping Real Time".CASE WHEN Timestampdiff(sql_tsi_day,"- Shipment Details"."WSH_NEW_DELIVERIES_A3PL_NTRFC_TNSTNP_",current_date)<=5 THEN '1-5 ' WHEN Timestampdiff(sql_tsi_day,"- Shipment Details"."WSH_NEW_DELIVERIES_A3PL_NTRFC_TNSTNP_",current_date) BETWEEN 6 AND 15 THEN '6-15' WHEN Timestampdiff(sql_tsi_day,"- Shipment Details"."WSH_NEW_DELIVERIES_A3PL_NTRFC_TNSTNP_",current_date) BETWEEN 16 AND 30 THEN '16-30' WHEN Timestampdiff(sql_tsi_day,"- Shipment Details"."WSH_NEW_DELIVERIES_A3PL_NTRFC_TNSTNP_",current_date)>30 THEN '> 30' ELSE 'NA' END FROM "Distributed Order Orchestration - Fulfillment Lines Real Time"
|
|---|
Any help is appreciated
