Parameterized bracket filtering

[Tom]

Hi,

I have 2 questions (suggestions) for bracket filtering.

1. Parameterized bracket filtering - is it possible ?

   This example does not work through OrientJS which can be very useful in complex query's.

    var sql = "select out('HAS_COMMENT')[name=:user] from #12:2";

    db.query(sql, {param: {user :'tom'}}).then(...)

    So I have to use standard approach like this one

    select from (

      select expand(out('HAS_COMMENT')) from #12:2

    ) where user = :user

   

2. Paging - java.lang.NegativeArraySizeException

   I'm using query like this

       select out('HAS_COMMENT')[420-50] from #12:2

   When first value is greater then number of edges in HAS_COMMENT, error is raised.

   

   So I have to use standard approach which works fine.

   select expand(comments) from (

     select out('HAS_COMMENT') as comments from #12:2

   ) skip 420 limit 50

   Also, as parameterized bracket filtering is not supported, I can't use from OrientJS something like this

   select out('HAS_COMMENT')[:start-:limit] from #12:2

I think that not only for where clause but wherever filtering values can be set (brackets), it should be possible to use parameters instead if needed.

For now, if I want to use parameterized bracket filtering, I have to use string replace function with some placeholders.

(I'm using Node.JS & OrientJS and 2.1RC OrientDB)

Tom