I am trying to use search on my object in 3 fields name, category, and tags, so now similar item three time

Welcome to Programming Tutorial official website. Today - we are going to cover how to solve / find the solution of this error I am trying to use search on my object in 3 fields name, category, and tags, so now similar item three time on this date .

views.py

 if search:
     wallpapers = Wallpaper.objects.filter(Q(name__icontains=search) | Q(category__category_name__icontains=search) | Q(tags__tag__icontains=search))

Html code

<form method="GET" action="/" class="d-flex">
  <input class="form-control me-2" name="search" id="search" type="search" placeholder="Search"
                    aria-label="Search">
  <button class="btn btn-outline-success" type="submit">Search</button>
</form>

Answer

It is possible that both the category and the tag match, and thus act as a “multiplier” for each other. You can work with .distinct() [Django-doc] to retrieve unique items:

if search:
    wallpapers = Wallpaper.objects.filter(
        Q(name__icontains=search) | Q(category__category_name__icontains=search) | Q(tags__tag__icontains=search)
    ).distinct()