How could i use "in" operators in parameters Filter

GSQL Queries
, ,
#1

In section Advanced Parameters for /graph/{graph_name}/vertices and /graph/{graph_name}/edges

Filter has six comparison operators:
= ,!= ,> , >= , < , <=

Could i use “in” operators in parameters Filter.
i want do query like: select * from A where id in [c,d,e];
so how can i deal with it by using restpp?

Looking forward to your reply.
Thanks.

#2

@ackerman

You can do a where with IN like this:
SELECT v FROM posts:v WHERE v.subject IN (“Graph”, “tigergraph”)

Using of IN operator over REST is not possible, but you can use a workaround using the query filter:

filter=id=‘c’,id=‘d’,id=‘e’

1 Like
#3

OK, fine.
Thank you!

#4

in the query filter,every column is combined with “and” operator. Is there an “or” operator?
In addition, does REST support fuzzy query? just like the “like” operator in mysql.

#5

Hi @ackerman,

the best way to do it would be to write a parameterized query, parse the values that you need using input variables and to run it using REST.

The OR operator can be used within WHERE clause.

And the LIKE too:

Best,
Bruno

#6

Fine,Thank you very much!

#7

In the Example : %abc% matches any string which contains the sequence “abc”.
abc is a string. IF i want to write a parameterized query,the abc is a param,How should i use LIKE operator?
%abc%? %{abc}% ? “%abc%”? or other?I see there is no specific example in the document.

#8

@ackerman

try “%” + abc + “%”

#9

I have solved it.
if i use “%” + abc + “%” in select directly like blow, it can not work:

Result = SELECT s FROM Start:s WHERE s.name_cn LIKE “%” + abc + “%”;

But if i do like this, it’ok:

string temp ;
temp = “%”+name+"%";
Result = SELECT s FROM Start:s WHERE s.name_cn LIKE temp;

2 Likes