For those who are interested, here is how I wrote the query. select @rid, @class, name, count(*) from (select expand(words) from document where date = '12/01/2013')
This did the trick. Thanks again. On Monday, December 23, 2013 1:29:35 AM UTC-5, [email protected] wrote: > > Hi All, > > I have created a document based graph that looks like this.. > > document > - id > - filename - type link -> liked to filename class > - filetype - type link -> liked to filetype class > - date - type link > liked to date class > - words - type linklist -> liked to words class > - paragraphs-- type linklist > liked to paragraphs class > > I was able to figure out how to write the following query > > select filetype, filetype.name, count(id) from documents where date.name= > '12/02/2014' > This returns a list of filetype RID, their name and a count of times their > are found in a document (using the id as a distinct counter) > > I want to do the same with words. For example > > select words, words.name, count(id) from documents where date.name = > '12/02/2014' > > This query does not return the concept RID and name and count. It simply > returns a record per document with the count set to 1. > > How can I get the same result as the first query from items in a linklist. > > Thanks > > -- --- 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/groups/opt_out.
