79426581

Date: 2025-02-10 09:23:45
Score: 0.5
Natty:
Report link

I think you're using wrong approach to use JSON_EXISTS, please try the below one:

select
    data
from test
where JSON_EXISTS(
    data::jsonb,  -- convert your data to jsonb first
    '$.criteria.employee_id.in'  -- corrected path of your expression
);

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Trusha Jadeja