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,
METADATAPROPERTIESINOUT
@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
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/427:59>
package_master 107 Package 10 4750 3000 #334:271
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/334:271>
11 1 11 36.842 false true 2016-12-22 15:33:12
#476:13
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/476:13>
#476:31
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/476:31>
#476:35
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/476:35>
#48:1635
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/48:1635>
#449:231
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/449:231>
#449:232
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/449:232>
#449:233
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/449:233>
#449:234
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/449:234>
#449:236
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/449:236>
#449:322
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/449:322>
..More(16)
#430:860
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/430:860>
#430:861
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/430:861>
#430:862
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/430:862>
#430:863
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/430:863>
#430:864
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/430:864>
#430:860
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/430:860>
package_services 3 850 536.843 36.842 false 2017-03-28 11:12:29 1 #300:7986
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/300:7986>
850
#427:59
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/427:59>
#430:861
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/430:861>
package_services 3 750 473.685 36.842 false 2017-03-28 11:12:29 1 #300:7984
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/300:7984>
750
#427:59
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/427:59>
#430:862
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/430:862>
package_services 3 150 94.737 36.842 false 2017-03-28 11:12:29 1 #300:7968
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/300:7968>
150
#427:59
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/427:59>
#430:863
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/430:863>
package_services 3 1400 884.212 36.842 false 2017-03-28 11:12:29 2 #300:9709
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/300:9709>
700
#427:59
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/427:59>
#430:864
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/430:864>
package_services 3 1600 1010.528 36.842 false 2017-03-28 11:12:29 2
#300:9710
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/300:9710>
800
#427:59
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/427:59>
#427:155
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/427:155>
package_master 7 Test Package 6000 5000 #334:269
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/334:269>
100 1 100 16.667 false true 2017-05-14 10:44:13
#48:1635
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/48:1635>
#449:592
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/449:592>
#430:946
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/430:946>
#430:947
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/430:947>
#430:946
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/430:946>
package_services 3 3000 2499.99 16.667 false 2017-05-14 10:44:13 2 #300:9695
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/300:9695>
1500
#427:155
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/427:155>
#430:947
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/430:947>
package_services 3 3000 2499.99 16.667 false 2017-05-14 10:44:13 2 #300:9696
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/300:9696>
1500
#427:155
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/427:155>
#427:156
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/427:156>
package_master 5 Package_test 3500 3000 #334:269
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/334:269>
100 1 100 14.286 false true 2017-05-14 10:46:04
#48:1635
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/48:1635>
#430:948
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/430:948>
#430:949
<http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/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?
--
---
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.
