add limit and offset params to all() method