Thank you Jeff, as always a clear explanation and detailed.

thank you Nigel, so detailed, and very well explained. I appreciate that

Thank You Timothy, for kindly taking the time to guide me. so clear explaination. Thank you

Thank you for this Timothy. Goes a long way.. so clear and able to understand well. 

That worked a charm Timothy, thank you. Can I ask, if I want to add an additional date field, how can  I add a between clause in the createSearchResult set method? so

Where name starts with

And Somedate BETWEEN ?(datefilter1) and ?(datefilter2)

You can get the value by : zenPage.getComponentById('dtfrom').value;

Thank You Julius, very informative for me. Gives me an idea of the different ways I can implement the solution