Hi, distinct() works on result set (multiple records), but if you have a collection to filter, you're right: asSet() is what does the job.
Lvc@ On 29 September 2014 17:40, Olakunle Olaniyi <[email protected]> wrote: > Here is a sample of what am trying to do with it : > > i have a query that returns a collection like I stated above > [a,a,a,b,b,c,g,f] (parenthesis intentionally omitted) . When i use > distinct([a,a,a,b,b,c,g,f]) it returns the same collection as before > [a,a,a,b,b,c,g,f] . > But the method asSet() returns distinct elements as I expected. > > Hope this helps. > > On Mon, Sep 29, 2014 at 5:33 PM, Luca Garulli <[email protected]> wrote: > >> Olakunle, >> the "doesn't work" in IT means nothing, please be more precise: >> - do you have any exception? >> - what's the query? >> - what's the db content? >> >> Lvc@ >> >> On 29 September 2014 17:31, Olakunle Olaniyi <[email protected]> wrote: >> >>> Tried it already, it doesn't work. >>> >>> On Mon, Sep 29, 2014 at 5:22 PM, Luca Garulli <[email protected]> >>> wrote: >>> >>>> You can use the distinct() function: >>>> >>>> >>>> http://www.orientechnologies.com/docs/last/orientdb.wiki/SQL-Functions.html#distinct >>>> >>>> Lvc@ >>>> >>>> On 29 September 2014 17:20, Olakunle Olaniyi <[email protected]> >>>> wrote: >>>> >>>>> Hello, >>>>> My question refers to this article ; >>>>> >>>>> http://www.orientechnologies.com/orientdb-improved-sql-filtering/ >>>>> >>>>> >>>>> >>>>> This is a great feature no doubt. But what if I am only interested in >>>>> getting distinct friend names from the list and say not the first or the >>>>> last or some data with a know index? >>>>> E.g for a collection such as ['a','a','b','c','c','g'] I would like to >>>>> get back (a,b,c,g). >>>>> How can i achieve that ? >>>>> >>>>> >>>>> Thanks, >>>>> >>>>> Olakunle >>>>> >>>>> -- >>>>> >>>>> --- >>>>> 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. >>>>> >>>> >>>> -- >>>> >>>> --- >>>> You received this message because you are subscribed to a topic in the >>>> Google Groups "OrientDB" group. >>>> To unsubscribe from this topic, visit >>>> https://groups.google.com/d/topic/orient-database/JfhWJhGu4FY/unsubscribe >>>> . >>>> To unsubscribe from this group and all its topics, send an email to >>>> [email protected]. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >>> >>> -- >>> Olakunle >>> >>> -- >>> >>> --- >>> 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. >>> >> >> -- >> >> --- >> You received this message because you are subscribed to a topic in the >> Google Groups "OrientDB" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/orient-database/JfhWJhGu4FY/unsubscribe >> . >> To unsubscribe from this group and all its topics, send an email to >> [email protected]. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Olakunle > > -- > > --- > 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. > -- --- 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.
