I have created a database with two vertices in it. Stores, Products. Stores
have a GeoSpatial Index. There is an Edge 'hasInventory' from store to
products. Now If I have to find a SKU in near by stores how should I
proceed.
I tried like:
SELECT expand(in('hasInventory').count(*)) FROM Products WHERE sku =
'8907103076739'
-- Second Query
Select in.@rid,in.name,out.@rid,out.name,out.lat,out.lon,quantity from
hasInventory where in.sku = '8907103076739'
-- Third Query
Select in.@rid,in.name,out.@rid,out.name,out.lat,out.lon,quantity from
hasInventory where in.sku = '8907103076739' and [out.lat,out.lon,$spatial]
NEAR [19.195524,72.834810,{"maxDistance" : 10}]
I want to understand in such cases when I have to traverse to other
vertices in query and apply "where" clause on the result of other vertices
how it can be done.
--
---
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.
