Hi Luigi,
Thanks for the suggestion, but I was hoping to it using a query builder. I
can write queries which have or,and with operator as "=" but if I need to
do a "and","or" query with a mixed operators.
For example let's say i have student table with columns as age,name and i
want to query
"select from student where (name = 'abc' and age > 20) or (name = 'pqr' and
age > 22) "
How can i achieve this?
I tried
db.select().from('student').or({"name":"abc","age":20},{"name":"pqr","age":40})
but this works fine and gives or query with all operator as equal to
On Friday, July 31, 2015 at 2:25:43 PM UTC+5:30, Luigi Dell'Aquila wrote:
>
> Hi Vipul,
>
> the easiest way is to use a plain SQL statement, see
> https://github.com/orientechnologies/orientjs#execute-a-select-query-with-params
>
>
>
> 2015-07-30 13:22 GMT+02:00 Vipul Maheshwari <[email protected]
> <javascript:>>:
>
>> Hi,
>>
>> Can someone please help to write a Or query with orientJs?
>>
>> --
>>
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "OrientDB" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected] <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
