limit（）method is not work.

[xiaobopang]

hello, when i use limit() method query ,i get return results is not what i want . public static function queryNearby($longitude, $latitude, $maxdistance, $pageSize = 10, $pageNumber = 0) { $param = array( 'loc' => array( '$nearSphere' => array( '$geometry' => array( 'type' => 'Point', 'coordinates' => array(doubleval($longitude), doubleval($latitude)), ), '$maxDistance' => $maxdistance //$maxdistance*1000 ) ) ); $columns = ['id','store_name','address','commercial_activities','status','loc','district_no']; $cursor = Stores::query()->where($param)->columns($columns)->limit((int)$pageSize,(int)($pageNumber))->get(); $result = $cursor->toArray(); return $result; }

[callmejea]

what you did at last? in fact, that's offset caution the error, but I don't know what to do , I'm new in mongodb; when the offset is smaller than 10 , that's good; here i have the same error, when set limit(10,$offset); $query is request from url; it stoped and return an empty array, the code is :

ModelName::query()->orderBy("_id","desc")->limit(10, $offset)->get()

php version is : 7.1.6 mongodb : 3.4 Phalcon-mongodb-odm : 1.0.6

[callmejea]

now I do like this:

where("_id", ">", new \MongoDB\BSON\ObjectId("59fa847a9c565bd0ccf2a9a4"))