Hi ,
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 function
var 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] // worksThe 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.