Search by parameters like with special characters
https://icatplus.esrf.fr/catalogue/{sessionId}/dataset?investigationIds=471183885,1487186864,584580539,1687043193¶meters=Sample_name~like~FO-20.129_lung-right
vs
https://icatplus.esrf.fr/catalogue/{sessionId}/dataset?investigationIds=471183885,1487186864,584580539,1687043193¶meters=Sample_name~like~FO-20.129_lung_right
The Sample_name is FO-20.129_lung-right_upper-lobe_core-biopsy
, so only the first request must return the dataset.
=> need to escape the underscore by replacing _
by |_
(.replace(/[_]/gi, "\\_")
) and add ESCAPE '\\'
so the query becomes LOWER(parameter.stringValue) LIKE '%fo-20.129\_lung\_right%' ESCAPE '\'