How to query with multiple conditions with Query.jl?


hoping someone can help me out with the syntax Julia Query uses, or maybe I am missing something, but basically trying to replicate a query command using contains, instead of having bunch of “||” statements.


IndexOne |> @query(i, begin
@where i.X1 == "ab1" || i.X1 == "ab2" || i.X1 == "ab3" 
@select (X1 = i.X1)
end) |> DataFrame 

cant quite get it to work with something easier like @contains(i.X1 = (“ab1”, “ab2”, “ab3”) )

You can just write i.X1 in ("ab1", "ab2", "ab3").

yep that worked… much easier haha - didnt realize “in” was supported.