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
Il giorno giovedì 8 giugno 2017 13:17:42 UTC+2, Pugazharasan Thirumalai ha
scritto:
>
> 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.
