It looks like I found a solution using this kind of expression: "SELECT VALUE t FROM c.Metadata WHERE t IN ({split($prctr, ',')})". I also had to adapt the value I am reading from the file, changed it from ('P00610','P00612') into P00610,P00612. So hope this would help someone in the similar case.