Display entry field if it contains search query

Question

Is it possible to display an entry field in search results if it contains the search query?

Context: I have an entry with a list of PDF assets. I want to show an asset in the search results if it contains the search query in the asset title. By default all the asset titles would display if any one contains the search query.

This is what I have in mind:

{% set searchQuery = craft.app.request.getParam('q') %}
{% set entries = craft.entries
  .section([
  'and', 'resources'
  ])
  .search(searchQuery)
  .orderBy('score')
  .all() %}
{% if entries|length %}
  <ul>
  {% for entry in entries %}
  <li><a href="{{ entry.url }}">{{ entry.title }}</a><br>
          {% set block = entry.downloads.all() %}   
          {% if block|length %}
                {% for file in block %}
                  {% for asset in file.file.all() %}
                  
                  {% if asset ***CONTAINS SEARCHQUERY*** %}
                      {{ asset.title }}
                  {% endif %}   
                  
                  {% endfor %}<br>
                {% endfor %}
          {% endif %}   
</li>
  {% endfor %}
  </ul>
{% endif %}

Answer 1

Like all relational fields, Assets fields return an ElementQuery instance (element queries are basically pre-baked query builders for fetching elements). You can use that ElementQuery's title() parameter to narrow down results based on assets' titles, including fuzzy searching. Here's how you could query for only assets with a title that contains the search query:

{% for asset in file.file.title('*' ~ searchQuery  ~ '*').all() %}
    {{ asset.title }}
{% endfor %}

Basically, the above appends * before and after the search query, which tells the ElementQuery returned by the Assets field (file.file, in your case) to only query for assets with titles that contain the search query somewhere.

There are other possible syntaxes available as well, depending on how you want to approach the title matching – see the official docs for more info.