Query on double indexing

[pugazh...@waffor.com]

Hai,

METADATA			PROPERTIES							IN	OUT
@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	customer	11	1111111131	2017-10-14 17:17:34	ha...@woor.com	Santhosh	false	male	#25:2049	#297:106317	#351:15393	#339:13080	#302:18050	#346:16985	#443:420	#438:1198	#280:37779	#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 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.

[Luigi Dell'Aquila]

Hi,

The query seems to be correct, could you please post a simple SQL script to reproduce the exact case?

Thanks

Luigi

--

---
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 orient-database+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Luigi Dell'Aquila]

Oh, sorry, you are trying to do a LIKE. Indexes cannot be used for LIKE operations with left and right wildcars

Thanks

Luigi