orientechnologies / orientjs

The official fast, lightweight node.js client for OrientDB
http://orientdb.com
Other
326 stars 68 forks source link

Filter on undefind value don't return vertices #408

Open smehdi21 opened 5 years ago

smehdi21 commented 5 years ago

hello, orientjs version: 3.0.8 orientdb version: 3.0.10

Filter on null Property != "String" not work using orientJs but work fine using the orientdb studio

Exemple 1 :

    const result1 = await odb.query("select from V where nullValue != 'true' ");
    console.log(result1)

result :

    Array(0) []

Exemple 2 :

    const result2 = await odb.query("select from V where  nullValue IS NOT DEFINED  ");
    console.log(result2)

result :

    Array(29) [Object, Object, Object, Object, Object, Object, Object, Object, …]
wolf4ood commented 5 years ago

Hi @smehdi21

which API of OrientJS are you using?

This one http://orientdb.com/docs/3.0.x/orientjs/OrientJS-Legacy.html

or

http://orientdb.com/docs/3.0.x/orientjs/OrientJS.html

Thanks

smehdi21 commented 5 years ago

Hi, We use the old API one. migration is planned but not done yet. Thanks