On Monday, May 4, 2015 at 8:31:21 PM UTC-5, Kun Liu wrote: > > Dear all, > > I am trying to use the feature of REST/HTTP API in OrientDB. I have a > cluster called Car which has 300 records in the database DBtemp1. However, > when I execute *http://localhost:2480/cluster/DBtemp1/Car > <http://localhost:2480/cluster/DBtemp1/Car>* in browser, it only shows me > 20 records. Two questions: > > 1) Does anyone know how I should adjust the http address > *http://localhost:2480/cluster/DBtemp1/Car > <http://localhost:2480/cluster/DBtemp1/Car>* so that the output includes > all of the 300 records? > 2) I want to execute the query *Select name from Car Limit 500* in HTTP > API. However, when I execut > *http://localhost:2480/query/DBtemp1/sql/Select%20name%20from%20Car%20Limit%20500 > > <http://localhost:2480/query/DBtemp1/sql/Select%20name%20from%20Car%20Limit%20500>*, > > it still only gives me 20 records. Any ideas about how to display the > entire 300 records by using *Select* statement in REST/HTTP API? > > Thank you! > > Kun >
from the manual, The same query with the limit to maximum 20 results using the fetch plan *:-1 that means load all recursively: HTTP GET request: http://localhost:2480/query/DBtemp1/sql/select name from car/500 remove limit -- --- 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.
