Searching for records

Searching for records is also a common operation in business logic methods. This recipe shows you how to find the book by name and category.

Getting ready

This recipe will use the same library.book definition as the Creating new records recipe did previously. We will write the code in a method called find_book(self).

How to do it...

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

1. Add the find_book method to the library.book model:

   def find_book(self): 
       ...

2. Write the search domain for your criteria:

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