I have a requirement where i need to replace GetNextWork listviews with report definition or SQL.

The requirement is we have a property called duedays in pyWorkpage and this will contain remaining days to complete the case. When user click GetNext i need to fetch next case which has less number of days to complete to process. 

This needs to be implemented with out using Getnextwork list views. Basically we need to customize GetNext functionality without using deprecated list views.

Can some one please help me with detail process how to replace listviews here with some other rules step by step.

Thanks in advance.