Skip to Content
0
Jul 17, 2020 at 01:23 PM

Data Intelligence: Dynamic SQL functions are not working in open connector SQL Operator

165 Views Last edit Jul 17, 2020 at 01:24 PM 2 rev

Hi Team,

I am trying to use Open connector SQL Consumer Operator in a graph to fetch incidents from ServiceNOW.

But I am not able to use dynamic SQL functions in WHERE clause. (WHERE "sys_updated_on" > '2020-07-16' --> is working fine)

Below is the SQL I am using.

SELECT "number", "opened_at", "closed_at", "assigned_to"
FROM incidents 
WHERE "sys_updated_on" >= add_days(current_date,-1)

Below is the error:

Group messages: 
Group: default; Messages: Graph failure: flowagenttableproducer1 failed with the following error: HTTP 400 Bad Request: {"requestId":"5f0f259ae4b0d503xxxxxxxx","message":"com.cloudelements.executor.service.query.expression.BaseFieldNameExpression cannot be cast to com.cloudelements.executor.service.query.expression.BaseFieldValueExpression"} 
Pod is failed. Container is terminated. Error. ExitCode=1. Signal=0

Can someone help me to solve this error.

Thanks in advance.

Regards,

Suchen.