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
--
---
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.
