# Paging, Sorting and Filtering

The RESTful API created by Remult supports server-side paging, sorting, and filtering. Let's use that to limit, sort and filter the list of tasks.

# Limit Number of Fetched Tasks

Since our database may eventually contain a lot of tasks, it make sense to use a paging strategy to limit the number of tasks retrieved in a single fetch from the back-end database.

Let's limit the number of fetched tasks to 20.

In the fetchTasks function, pass an options argument to the find method call and set its limit property to 20.

src/App.vue



 



async function fetchTasks() {
  tasks.value = await taskRepo.find({
    limit: 20
  });
}

There aren't enough tasks in the database for this change to have an immediate effect, but it will have one later on when we'll add more tasks.

TIP

To query subsequent pages, use the Repository.find() method's page option.

# Show Active Tasks on Top

Uncompleted tasks are important and should appear above completed tasks in the todo app.

In the fetchTasks function, set the orderBy property of the find method call's option argument to an object that contains the fields you want to sort by. Use "asc" and "desc" to determine the sort order.

src/App.vue




 



async function fetchTasks() {
  tasks.value = await taskRepo.find({
    limit: 20,
    orderBy: { completed: "asc" }
  });
}

Note

By default, false is a "lower" value than true, and that's why uncompleted tasks are now showing at the top of the task list.

# Toggle Display of Completed Tasks

Let's allow the user to toggle the display of completed tasks, using server-side filtering.

  1. Add a hideCompleted ref field and Modify the fetchTasks function, and set the where property of the options argument of find:

src/App.vue

 




 



const hideCompleted = ref(false);
async function fetchTasks() {
  tasks.value = await taskRepo.find({
    limit: 20,
    orderBy: { completed: "asc" },
    where: { completed: hideCompleted.value ? false : undefined }
  });
}

Note

Because the completed field is of type boolean, the argument is compile-time checked to be of the boolean type. Settings the completed filter to undefined causes it to be ignored by Remult.

Learn more

Explore the reference for a comprehensive list of filtering options.

  1. Add a checkbox input element immediately before the tasks map in App.vue, bind its check state to the hideCompleted state, and add a change handler which calls fetchTasks when the value of the checkbox is changed.

src/App.vue


 
 
 
 





  <template>
  <div>
    <input type="checkbox" v-model="hideCompleted" @change="fetchTasks()" /> Hide Completed 
    <main>
      <div v-for="task in tasks">
        <input type="checkbox" v-model="task.completed" />
        {{ task.title }}
      </div>
</template>

After the browser refreshes, a "Hide completed" checkbox appears above the task list. The user can toggle the display of uncompleted tasks using the checkbox.