Traverse skip and limit are not working

[Pugazharasan Thirumalai]

Hai,

We are using  OrientDB version : 2.0.18,

When i execute below the query,

select from (traverse out('package_has_service') from (select expand(out('store_has_package')[is_deleted = false]) from #48:1635))

Am getting the result as,

METADATA			PROPERTIES														IN				OUT
@rid	@class	@version	name	cost_price	special_price	tax	validity_count	validity_type	validity_days	discount	is_deleted	is_status	created_date	quantity	service_id	unit_price	commission_profile_has_package	store_has_package	generated_package_has_master_package	package_has_service	package_has_service
#427:59	package_master	107	Package 10	4750	3000	#334:271	11	1	11	36.842	false	true	2016-12-22 15:33:12				#476:13 #476:31 #476:35	#48:1635	#449:231 #449:232 #449:233 #449:234 #449:236#449:322 ..More(16)		#430:860 #430:861 #430:862 #430:863 #430:864
#430:860	package_services	3		850	536.843					36.842	false		2017-03-28 11:12:29	1	#300:7986	850				#427:59
#430:861	package_services	3		750	473.685					36.842	false		2017-03-28 11:12:29	1	#300:7984	750				#427:59
#430:862	package_services	3		150	94.737					36.842	false		2017-03-28 11:12:29	1	#300:7968	150				#427:59
#430:863	package_services	3		1400	884.212					36.842	false		2017-03-28 11:12:29	2	#300:9709	700				#427:59
#430:864	package_services	3		1600	1010.528					36.842	false		2017-03-28 11:12:29	2	#300:9710	800				#427:59
#427:155	package_master	7	Test Package	6000	5000	#334:269	100	1	100	16.667	false	true	2017-05-14 10:44:13					#48:1635	#449:592		#430:946 #430:947
#430:946	package_services	3		3000	2499.99					16.667	false		2017-05-14 10:44:13	2	#300:9695	1500				#427:155
#430:947	package_services	3		3000	2499.99					16.667	false		2017-05-14 10:44:13	2	#300:9696	1500				#427:155
#427:156	package_master	5	Package_test	3500	3000	#334:269	100	1	100	14.286	false	true	2017-05-14 10:46:04					#48:1635			#430:948 #430:949

I want to use skip and limit for class "package_master", so i execute the query like,

select from (traverse out('package_has_service') from (select expand(out('store_has_package')[is_deleted = false]) from #48:1635) skip 0 limit 1)

but its not working same result is displaying.

How to apply skip and limit on "package_master" class?

[Ivan Mainetti]

try 

select from (traverse out('package_has_service') from (select expand(out('store_has_package')[is_deleted = false]) from #48:1635)) skip 0 limit 1

[Ivan Mainetti]

why are you using such an old version?!

 

 

[Pugazharasan Thirumalai]

If i run the below code

select from (traverse out('package_has_service') from (select expand(out('store_has_package')[is_deleted = false]) from #48:1635)) skip 0 limit 1

Am getting result as,

METADATA			PROPERTIES											IN			OUT

@rid	@class	@version	name	cost_price	special_price	tax	validity_count	validity_type	validity_days	discount	is_deleted	is_status	created_date

generated_package_has_master_package	store_has_package	commission_profile_has_package	package_has_service

#427:59

package_master

107

Package 10

4750

3000

#334:271

11

1

11

36.842

false

true

2016-12-22 15:33:12

#449:231 #449:232 #449:233 #449:234 #449:236#449:322 ..More(16)

#48:1635

#476:13 #476:31 #476:35

[Pugazharasan Thirumalai]

Actually we planned to migrate to newer version but we have to change query on many places based on newer version, that's why we are using the same version.

[Ivan Mainetti]

ok, could you better explain your DB structure (edges, vertices, connection between them) , or at least the part involved in this query?

thank you

Ivan

[Pugazharasan Thirumalai]

Hai,

Vertex - package_master

Edge - package_has_service

Vertex -package_services

package_has_service edge between package_master and package_services

Each package has multiple services,

So i want package with list of services

for example,

[Ivan Mainetti]

So, I suppose that select expand(out('store_has_package')[is_deleted = false]) from #48:1635 returns a list of package_master, right?

In this case I think you can limit them like 

select from (traverse out('package_has_service') from (select from (select expand(out('store_has_package')[is_deleted = false]) from #48:1635) skip 0 limit 1))

[Pugazharasan Thirumalai]

Hai Ivan Mainetti ,

Thank you so much....

Its working,

And we are facing performance issue when customer is increase, so many customers disappointment on our product.

So can i get your skype id to contact you.

Thanks and Regards,

T.Pugazharasan.

[s.l...@orientdb.com]

Hi Pugazharasan Thirumalai,

This is a community mailing list, you can't expect that type of support.

OrientDB LTD, the company behind the OrientDB suite of products, does provide different support subscriptions: http://orientdb.com/support/ and a consultancy service: http://orientdb.com/consulting/

Please consider to become a customer of us. We will help you upgrading to a newer (supported) version and changing / optimizing the queries you are using to get better performance

To contact us: http://orientdb.com/contact/

Thanks,