Hi Ricardo, I was thinking about your proposal:
SELECT shortestPath(#8:32, #8:10, 'both', Workin.date="2010-05-01") And I found something easy to implement: SELECT shortestPath(#8:32, #8:10, 'both', ( Workin.date="2010-05-01") ) With parenthesis, we could easily parse the expression and apply it. Could you open a new issue for that? Unfortunately we're super busy to release v2.2.0-rc1 and this feature could be implemented not before a couple of months. Best Regards, Luca Garulli Founder & CEO OrientDB <http://orientdb.com/> On 24 November 2015 at 06:26, Ricardo A. Pasquini <[email protected]> wrote: > Thanks very much Scott and Luca. Yes, indeed I am looking for something > more like: > > SELECT shortestPath(#8:32, #8:10, 'both', Workin.date="2010-05-01") > > Which would involve first selecting a graph (edges) that exist in a given > date, and second obtaining the shortest path for that specific graph. > I will write a function in Javascript as Luca suggests. Since I have so > many dates the optimization is key. I will let you know what best solution > I can find. > Thanks a lot, and regards > > Ricardo Pasquini > > > On Tuesday, November 24, 2015 at 9:27:55 AM UTC-3, l.garulli wrote: >> >> The only function that works out of the box is dijkstra(), otherwise you >> could write your own function that is optimized for your case. you could >> write it in Javascript under OrientDB Server function and then call it from >> SQL: >> >> select myShortestPath(#8:32, #8:10, "2010-05-01") >> >> Best Regards, >> >> Luca Garulli >> Founder & CEO >> OrientDB <http://orientdb.com/> >> >> >> On 23 November 2015 at 23:27, scott molinari <[email protected]> >> wrote: >> >>> I believe Ricardo is looking for something like >>> >>> SELECT shortestPath(#8:32, #8:10) WHERE Workin = "2010-05-01" >>> >>> >>> Scott >>> >>> -- >>> >>> --- >>> 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. > -- --- 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.
