[orientdb] Re: select @rid from expand() not working

Alessandro, this makes sense now. The relational db concepts gotten on my way of thinking.The @rid is referenced so heavily everywhere that I started to believe it is a regular field instead of being a metadata. Quick question though, in the relational world we typically add an id column to a

Re: [orientdb] Re: select @rid from expand() not working

Hi Luigi. Pardon me if it's too verbose, but here is the full picture: // Account class create class Account extends V create property Account.id INTEGER (DEFAULT "sequence('accountId').next()", READONLY TRUE) create property Account.created DATETIME (DEFAULT "sysdate()", READONLY TRUE) create

[orientdb] Re: Let is not working on sub-query

Thanks for the response. Your solution also returns the result, but as Luigi mentioned the key is to treat the sub-query as a resultset. On Tuesday, October 25, 2016 at 11:43:51 PM UTC-7, Oleksandr Gubchenko wrote: > > Can you try this one? > > select $aa.@rid, a from B > let $aa = (select from

Re: [orientdb] Re: Let is not working on sub-query

Thanks Luigi, it worked. I didn't think in terms of a resultset, but it makes sense. On Tuesday, October 25, 2016 at 11:51:21 PM UTC-7, Luigi Dell'Aquila wrote: > > Hi, > > The result of a subquery is a result-set, not a single element. I think > that rewriting the query this way it should

[orientdb] Let is not working on sub-query

Hello, I seem to run into a wall while trying to figure the LET statement which is just failing on me, Here are 2 classes where one has link to another. I need to use the LET statement to get the linked class by provided id, but the result never returns any records. Sub query does return the

[orientdb] Re: select @rid from expand() not working

Unfortunately it didn't work. Also, I need to return all properties, not just @rid. And to make things more complicated this is a simple query, but the other one I have is chaining more in(), out() to get to nodes about 3 levels deep. The queries work, but the final vertex must return all

[orientdb] select @rid from expand() not working

Hello, I'm running OrientDB 2.2.12 on Mac/Linux I'm trying to perform a simple out() lookup from a class and get all properties of another class. I can get all properties except @rid. I tried different ways, but nothing seem to work or return the @rid. How do I get the @rid as a property? Here

[orientdb] Re: Property Enums Support?

Thanks for the respond Alessandro, Can you or someone clarify if there is a plan to implement it? In the old issue I couldn't figure out if it's left as is or is there a plan to actually implement enums in the future. On Monday, October 24, 2016 at 12:10:49 AM UTC-7, alessand...@gmail.com

[orientdb] Property Enums Support?

Just a quick question: do you plan to add Enum support to properties as an additional constraint? For example, a property "status" would benefit to have an Enum like 'not processed', 'processed', 'error', 'sent', etc. instead of creating another class to hold these values and do custom

[orientdb] Re: Namespacing for classes

This is really good discussion. I’m glad that I’m not the only one raising this question. On Wednesday, October 19, 2016 at 4:20:06 AM UTC-7, scott molinari wrote: > > There is also this OEP for version 3.0 suggested for namespaces. > >

[orientdb] Namespacing for classes

Hello document db gurus, I'm building a rather large orientdb database, which will contain classes many of which need to be grouped logically by names. I understand that class naming is advised to go by the Java conventions, which is great for a limited number of classes. However, java also

Re: [orientdb] Re: Can't remove embedded list item from 3 levels down

Bug submitted. On Thursday, October 13, 2016 at 9:51:57 AM UTC-7, Luigi Dell'Aquila wrote: > > Yes, please > > Thanks > > Luigi > > 2016-10-13 18:23 GMT+02:00 : > >> Thanks Luigi. Shall it be filed as a bug? >> >> >> >> On Wednesday, October 12, 2016 at 11:58:33 PM UTC-7,

Re: [orientdb] Re: Can't remove embedded list item from 3 levels down

Thanks Luigi. Shall it be filed as a bug? On Wednesday, October 12, 2016 at 11:58:33 PM UTC-7, Luigi Dell'Aquila wrote: > > Hi guys, > > Ok, it's correct, it "kind of" works because of some internal corner > cases, but it's definitely a dirty work around :-D > Anyway, I'll fix the main

[orientdb] Re: Can't remove embedded list item from 3 levels down

Hi Oleksandr, Interesting, I think it is similar or related to that issue of 5703. When I wrapped the whole string into `` characters it worked, or kind of worked. Check this out: orientdb {db=Tetraop}> update #25:0 remove `settings.leads.TempLead.overrideProperties[0]` Updated record(s) '1'

[orientdb] Re: Can't remove embedded list item from 3 levels down

Hi Michela, here are the schemas starting from the most inner class and up all the way to account. // Property Override create class PropertyOverride extends V create property PropertyOverride.standardProperty STRING (NOTNULL TRUE) create property PropertyOverride.customProperty STRING (NOTNULL

[orientdb] Can't remove embedded list item from 3 levels down

Hello, I have an embedded list implemented 3 levels down (3 embeddings from the root class). I seem to have a problem removing just inserted list element. I followed the examples in the manual and it works on a single embedding fine, but in my case it just fails. See below: // added record

Re: [orientdb] Re: Can't put more data into second level embedded map

You're right, it works and I'll use it that way for now. However, should I submit it as a bug orientDB team or is it something you working on to change in 3.0? On Tuesday, October 11, 2016 at 1:00:19 AM UTC-7, Luigi Dell'Aquila wrote: > > Hi, > > It seems there is a bug in the parser, but to

[orientdb] Can't put more data into second level embedded map

Hello, I'm sure I'm missing something, but I just can't figure it out from the online docs. I have a Class "Account", inside it has Embedded class "AccountSettings", which has another embeddedmap "classTemplate". I'm trying to add values to the embedded map "classTemplate", but the "put"

[orientdb] Saving JSON data with embedded objects fails

Hi guys, I hope I'm doing something wrong and it's not a shortcoming for the orientdb's functionality. I'm working on the application, which will need to store different objects of complex structure (objects inside of objects). For example, Person object may have Address object, Contacts, and

[orientdb] Unable to list connections

Hello guys, I'm new to OrientDB and trying to simply list connections but puzzled here if I'm doing something wrong or is it a bug. Every time I execute "list connections" I get an error message. I tried with root and admin users to no avail. Here are the steps I followed: iMac:developer