create manager functions for pagination query