Re: [orientdb] how to unwind multiple collection

I'm not sure you can do it, just because there is no deterministic way to do it. It is not even guaranteed that the second and third collection have the same number of items, so in general it is not a consistent operation. Perhaps you can consider to review your domain? Thanks Luigi Il giorno

Re: [orientdb] InvolvedIndex issue when executing Explain query

Hi I'm not sure I got the point, could you please provide a full SQL script to reproduce the problem? Thanks Luigi Il giorno sab 17 nov 2018 alle ore 06:29 axon musthaq ha scritto: > i have created several indexes in an vertex class > > example > > VERTEX > 1.employee as an index firstname >

Re: [orientdb] Remove special character from the attribute

Hi You can use replace() method: SELECT ip.replace(".", "") FROM V Thanks Luigi Il giorno ven 16 nov 2018 alle ore 19:50 axon musthaq ha scritto: > I have an property called ip in an vertex class > example > > ip:127.0.0.1 i need get the value as 127001 by removing dot(.) special >