Firstly, the insert that you have used seems to be incorrect. Correct query: Insert into test values (‘{ “description”:”employee”, “criteria”: { “employee_id”:{ “in”:[10137,12137,19137] } } }’);

Next, the query to be used to retrieve the 2 ids,

select * from test where data ->’criteria’->’ employee_id’->’in’ ?& array[10137,12137];

Try the above and check if it works…