Infinity UQL query with valid JSONata expression does not work

[sanbhattdeep]

Hi All,

I am trying to use a UQL query using JSONata expression as follows:
jsonata “$filter(data, function($v) {$millis()- $toMillis($substring($v.enrolled_on, 0, 10) & “T” & $substring($v.enrolled_on, 11, 19) & “Z”) <= 86400000}).{“customer_name”: customer_name, “platform”: platform}”

I have confirmed the jsonata expression is valid in https://try.jsonata.org/

But the same doesnt work from UQL - get error applying UQL query

[sanbhattdeep]

Resolved the issue by replacing the double quotes inside jsonata " " expression with single quotes