add offset and limit for get_all method