Hi,
I'm not sure I understood your use case, but I think what you need is
something like
select service_name from (
select
expand(out('store_has_service_group')['is_deleted =
false'].out('service_group_has_store_service'))
from #48:999
) WHERE ...
Thanks
Luigi
2016-11-19 7:05 GMT+01:00 Pugazharasan Thirumalai <[email protected]>:
> Hai,
>
> I have created list groups in database , each group contains some list of
> services, i want search the respective services from the group
> If i use this query i can get list of service from the group
>
> Query : select from (select
> out('service_group_has_store_service').service_name
> as service_name from (select expand(out('store_has_service_group')['is_deleted
> = false']) from #48:999))
>
> Output :
>
> PROPERTIES
>
> service_name
> ["new service"]
> ["orange peel bleach","sandal wood bleach","test","face bleach"]
> ["full body massage child"]
> ["gold","pugazh facial","golden facial","classic facial","pearl
> facial","fruit facial","fruit based facial spa - berry"]
> ["haircut service 1"]
> ["full body massage","head oil massage"]
> ["polish manicure","french manicure","gellish manicure"]
> ["full face","eyebrow"]
> ["basic cut","creative styles","blow dry"]
>
> from that i can't able search any services by where condition.
>
>
> Thanks and Regards,
> T.Pugazharasan.
>
> --
>
> ---
> 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.
