add range query in manager query