OrientDB

After several days and lots of views, it appears I've stumped StackOverflow. Can anyone can shed

Hi Steve Probably the problem here is that you have loops in your graph. I think the only solution so

I have a generic (non-V) class with a LINKMAP field that links a chain of time-series data. Each

+1, I'll do it asap 2017-10-19 18:00 GMT+02:00 Raymond Willems <sme...@me.com>: Thanks!

Hi Luigi, The edges go from parent to child so the 'scopeEdge' comes out of (a) and goes in

METADATA PROPERTIES @rid @version @class id idTag tagName xy z date type z2 #21:536 1 Tabz 142 973

Hi, do you have a test case to share? So in this way I can made some tests with a full and complete

Ah yes, sure, the second WHERE should be an AND ;-) Happy to see it helped Luigi 2016-12-23 16:06 GMT

Each EHR will have an EHR_status (without properties) but I do not know if it should be an edge or

Hi That's the right syntax, it's supposed to work fine. Could you please post a simple script

It worked just fine after correcting a mistyping and adding, actually guessing, the phrase:

Hi Luca, I have deployed a new instance on Ubuntu 14.04 and redo tests, the performance is stable and

Hi David, Unfortunately for ORDER BY Priority DESD, DueTime ASC there is no technical solution in

Hi Hung, try with select eval('(Perform.EndDate - Perform.BeginDate) / 1000'), Statistics.

Hi, In my latest tests before migrating from 1.7.8 to version 2.1.8. With earlier version, an kind of

Hi Alessandro, Thank you for helping me to understand it. By document, you seem to be right, but it

Hi, It should not reduce the result set to a single row. In other database engines, the aggregate

Sorry, I misunderstood. You can also use the following query: SELECT count(distinct(Contact)) FROM

Hi Luigi, I have enclosed the database file in attachment. Thank you for your concern. This is not

Thanks for responding friend thought that way do I have another solution that you think select @rid,

Hi, try this query select $counter, @rid from v let $counter = eval("$counter + 1") Regards

Hi, I have just been migrated from version 1.7.8 to version 2.1.8. I have to comment out code related

Hi Alessandro, Thank for your response, it's working, understood the logic. However, as a result,

Hi Alessandro, OMG, it gives a better result. 2-2.5 sec instead. Look at its explain, I don't

Hi Alessandro, You could see the query in each image. Anyway, here they are SELECT @rid as __x1,

Hi Luca, I tried, the result is the same. I used HASH_INDEX because I don't need ORDER BY on that

Hi guys, FIND REFERENCES command is not intended to be used in typical production environments. Links

Hi Hung Tran, I would advise you to use your first 'Working SQL' in this case but if you want

Hi, I have tried this code and it works with 2.1.8 HashMap<String, Object> params = new HashMap

Hi Luigi, An issue is created https://github.com/orientechnologies/orientdb/issues/5589 My Best, Hung