Buttns for - show all, show assigned, show completed etc.

Hi,
Apologies if this has been answered before but I couldn't find anything when searching.
I have a runner site that shows a team a list of jobs in the List view.

The default filter is to show non completed jobs that are either assigned to them or not yet assigned.

However we also need a set of buttons to change what is displayed to show selections such as 'show all' 'show completed' etc. so that they can see other data as well as the default filter.
There are code snippets I can add to modify the where to change the filter such as:

function OnBefore(params,ctrl)

{

$query->replaceWhere(" jobStage='complete' ");

}
However I am stuck on how to get it to then re-run the query and reload the page with the new data.

(I can do all I need for this task with new where clauses, but can redo the whole sql if that helps)
Anyone know the best way to do this?

A) Change the where clause

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=20148&image=1&table=forumtopics' class='bbc_emoticon' alt='B)' /> Re-run the query

C) Load the new data