[orientdb] Re: A query gets a parsing error with LIMIT statement

Hi Hung, Try this: SELECT first(eval('$TotalListsQuery[0].Count')) AS TotalLists LET $TotalListsQuery = (SELECT Count(1) AS Count FROM ContactList WHERE Account=#20:1 AND EntityInfo.State=0) Regards, Michela -- --- You received this message because you are subscribed to the Google Groups

Re: [orientdb] Re: A query gets a parsing error with LIMIT statement

Hi Luigi, An issue is created https://github.com/orientechnologies/orientdb/issues/5589 My Best, Hung Tran On Tuesday, January 12, 2016 at 4:08:34 PM UTC+7, Luigi Dell'Aquila wrote: > > It seems to be a bug, could you please open an issue about this? > > Thanks > > Luigi > > > 2016-01-12 10:06

Re: [orientdb] Re: A query gets a parsing error with LIMIT statement

It seems to be a bug, could you please open an issue about this? Thanks Luigi 2016-01-12 10:06 GMT+01:00 : > Hi Hung, > > Try this: > > SELECT first(eval('$TotalListsQuery[0].Count')) AS TotalLists > LET $TotalListsQuery = (SELECT Count(1) AS Count FROM ContactList