Thanks Gayathri and Giani, I am using OAC. After understianding why it was failing what I have done is to create a view of the real table and then converting it to text. CREATE ALGORITHM = UNDEFINED DEFINER = bastion@% SQL SECURITY DEFINER VIEW roaming AS SELECT SmPolicyAssociation.SUPI AS SUPI, CONVERT(…

Ok I will check. Possibly the problem is with the output of the query. Json type fileds are not supported but if I convert them the query should work as you say. Thanks

Thanks to both . I have changed the approach to it now. I am creating a view of the JSON field to varchar so I dont have problems managing JSON from OAC. CREATE ALGORITHM = UNDEFINED DEFINER = bastion@% SQL SECURITY DEFINER VIEW roaming AS SELECT SmPolicyAssociation.SUPI AS SUPI, CONVERT( SmPolicyAssociation.k USING…