Hi Alessandro, Thank you for helping me to understand it. By document, you seem to be right, but it seems to be not really useful. I really hope it has a different meaning which will return any record which the property contains all value of the given subset.
My Best, Hung Tran On Monday, March 14, 2016 at 10:55:56 PM UTC+7, [email protected] wrote: > > Hi Hung, > as my undestanding, containsall 'b' will return all records where *all > values of xMultiValue* property contains "b". > > See the documentation > http://orientdb.com/docs/2.0/orientdb.wiki/SQL-Where.html#conditional-operators > > I have found > "true if all the elements of the collection satisfy the next condition". > > Example > > > <https://lh3.googleusercontent.com/-ngFuVWaPdgU/VubeP0QpRAI/AAAAAAAAALc/_TpvBqBXHjYV6igQ0VMm-Ukix9hlCT10Q/s1600/1.png> > > > Only for the record #9:5 the property xMultiValue contains all values "b". > > The record #9:0 contains also "a", #9:3 contain also "a" and "c" and #9:7 > contains also "c" and "c" > > > <https://lh3.googleusercontent.com/-pOVtome10Xs/Vubff0HHtCI/AAAAAAAAALs/NM9UwCAlnooCZz6zr3Q2QYf6IpyJMO4RQ/s1600/2.png> > > > > > <https://lh3.googleusercontent.com/-CVZmagNAtnc/Vube80CtxDI/AAAAAAAAALo/WHA4tJEOkWQjPu5gFwX1zRuEHtX_ozRVA/s1600/3.png> > > Hope it helps. > -- --- 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.
