We are experimenting with OrientDB for a POC project. We want to implement a simple search server-side function.
The plan is to receive an array of strings as an input parameter, pass it to the query and return the result (to prevent sql injection)
Here is a snippet of our server side functionvar ids = (idsInput) ? JSON.parse(idsInput) : null; // ids will be an array of string like ["#75:0"]
The issue is that "CONTAINS" condition dose not work with array of strings.select * from Article where in() CONTAINS [#75:0] // works
The way we see it we have two options :
We didnt able to do it in either way.
Is there a way to do one of the Items or a third way to solve this ?
Many thanks in advance.