Searching for records

Searching for records is also a common operation in business logic methods. There are many cases where we need to search the data based on different criteria. Finding the room by name and category is demonstrated in this tutorial.

Getting ready

This tutorial will use the same hostel.room definition as the Creating new records tutorial did previously. We will write the code in a method called find_room(self).

How to do it…

To find the rooms, you need to perform the following steps:

1. Add the find_room method to the hostel.room model:

   def find_room(self):
       ...

2. Write the search domain for your criteria:

   domain = [
       '|',
           '&', ('name', 'ilike', 'Room Name'),
                ('category_id.name', 'ilike', 'Category...