Hi, The query seems to be correct, could you please post a simple SQL script to reproduce the exact case?
Thanks Luigi 2017-10-21 10:42 GMT+02:00 <[email protected]>: > Hai, > > METADATAPROPERTIESINOUT > > @rid > @class > @version > mobile_no > created_date > email_id > name > is_deleted > gender > network_id > store_customer > customer_has_appointment > customer_has_billing > customer_has_store_service > customer_has_preferred_stylest > customer_has_wallet_inventory > customer_has_wallet_activity > customer_has_customer_feedback > customer_has_activity > #260:103808 > <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/260:103808> > customer 11 1111111131 2017-10-14 17:17:34 [email protected] Santhosh false > male #25:2049 > <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/25:2049> > #297:106317 > <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/297:106317> > #351:15393 > <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/351:15393> > #339:13080 > <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/339:13080> > #302:18050 > <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/302:18050> > #346:16985 > <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/346:16985> > #443:420 > <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/443:420> > #438:1198 > <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/438:1198> > #280:37779 > <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/280:37779> > #261:135035 > <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/261:135035> > > we have index the *customer* vertex as* customer.network_id_mobile_no* > > i want to query on index like, *network_id = #25:2049 > <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/25:2049> > and mobile_no > like '%1131%'* > > Below i have wrong query, can u modify it as per my requirement, > > select from index:customer.network_id_mobile_no where key = [#25:2049, > '%111131%'] > > Thanks and Regards, > T.Pugazhararasan. > > -- > > --- > 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.
