Hi Luca, Here you are
CREATE CLASS Contact CREATE PROPERTY Contact.Status INTEGER ALTER PROPERTY Contact.Status MANDATORY true ALTER PROPERTY Contact.Status NOTNULL true CREATE INDEX Contact.Status ON Contact (Status) NOTUNIQUE_HASH_INDEX CREATE PROPERTY Contact.EmailAddress STRING ALTER PROPERTY Contact.EmailAddress MANDATORY true CREATE PROPERTY Contact.EntityInfo EMBEDDED EntityInfo CREATE CLASS ContactList CREATE PROPERTY ContactList.Name STRING ALTER PROPERTY ContactList.Name MANDATORY true ALTER PROPERTY ContactList.Name COLLATE ci CREATE INDEX ContactList.Name ON ContactList (Name) UNIQUE_HASH_INDEX CREATE PROPERTY ContactList.Statistics LINK ListStatistics CREATE PROPERTY ContactList.EntityInfo EMBEDDED EntityInfo CREATE CLASS ListStatistics EXTENDS CREATE PROPERTY ListStatistics.NumActiveContacts INTEGER ALTER PROPERTY ListStatistics.NumActiveContacts MANDATORY true ALTER PROPERTY ListStatistics.NumActiveContacts NOTNULL true CREATE PROPERTY ListStatistics.NumContacts INTEGER ALTER PROPERTY ListStatistics.NumContacts MANDATORY true ALTER PROPERTY ListStatistics.NumContacts NOTNULL true CREATE CLASS EntityInfo CREATE PROPERTY EntityInfo.State INTEGER ALTER PROPERTY EntityInfo.State MANDATORY true ALTER PROPERTY EntityInfo.State NOTNULL true CREATE INDEX EntityInfo.State ON EntityInfo (State) NOTUNIQUE_HASH_INDEX My Best, Hung Tran On Friday, January 22, 2016 at 12:47:46 PM UTC+7, Luca Son wrote: > > Hi Hung Tran, > > could you post the entire schema to try the query ? > > Thanks > > Luca > -- --- 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.
