Hi ,
I new to using orientdb jdbc driver, try to retrieve records using sql
query but edge of @rid field return whole object of the records,
This is my java statement:
ResultSet rs = stmt.executeQuery("select in('employee_has_store_service')
as employee_id from (traverse out('service_has_pricing') from (traverse
out('service_group_has_store_service') from (select from (select
expand(out('store_has_service_group')['is_deleted = false']) from
"+storeId+") order by created_date desc) while is_deleted = false ) while
is_deleted = false) skip 0 limit -1");
Output:
employee_id :
[store_service_person#295:747{out_employee_has_store_service:[size=5],out_employee_has_employee_working_hours:[size=1],person_name:jayaraj,last_name:,email_id:,login_access:false,enable_appointment:true,service_level:#349:0,is_deleted:false,created_date:Tue
Aug 09 11:37:00 IST
2016,in_appointment_services_has_employee:[size=6],in_billing_services_has_employee:[size=4],mobile_no:,in_store_has_service_person:[size=1],in_billing_products_has_employee:[size=1]}
v3,
store_service_person#295:758{out_employee_has_store_service:[size=5],out_employee_has_employee_working_hours:[size=1],person_name:Ramachandran,last_name:,email_id:,login_access:false,enable_appointment:true,service_level:#349:0,is_deleted:false,created_date:Tue
Aug 09 14:24:39 IST
2016,in_appointment_services_has_employee:[size=10],in_billing_services_has_employee:[size=5],mobile_no:,in_store_has_service_person:[size=1]}
v3]
I am expecting output:
employee_id : ["#295:747","#295:758"]
Regards
Jayaraj
--
---
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.
