How to filter related content?

[daniel]

Hi Guys

I'm new to the template based possibilities with Twig and Doctrine and have to say it's a pleasure to work with.

But now i have a question:
How can i filter the results of the content.related() Query?
My actual Twig query looks like this and lists all Entries in the actual Page:

Code: Select all

{% set multiplecontent = content.related('entries') %}

Now i need to filter the list of entries by a "filter"-string.
I have no idea how to insert such an additional Query in this.
In SQL i would do something like

Code: Select all

.. AND title LIKE '%searchedword%''

The defined contenttypes:

Code: Select all

pages:
    name: Pages
    singular_name: Page
    fields:
        title:
            type: text
            class: large
            required: true
            index: true
        slug:
            type: slug
            uses: [ title ]
      ...


entries:
    name: Entries
    singular_name: Entry
    fields:
        title:
            type: text
            class: large       
        slug:
            type: slug
            uses: title
    relations:
        pages:
            multiple: false
            order: title
            label: Page

Does anyone has an idea?

[Bob]

With 'set' and '.related()' you can't pass extra query parameters. You can easily filter them when iterating over the results:

Code: Select all

{% for bla in multiplecontent if 'searchedword' in title %}
{{ bla.title }}
{% endfor %}


[daniel]

Thanks, that's great!

But how to handle this elegant with pagination. The displayed results are in this case not the same like in the query

Code: Select all

{% set multiplecontent = content.related('entries') %}

Tho get the correct amount of entries i have to iterate the whole array and check if the entries matches with the searchword.

Is there a trick to do it more elegant/speed efficient?

[Bob]

No, currently there's no really elegant way to do that. I could see someone writing an extension for that, but at the moment you'll have to resort to hackish solutions.

[jadwigo]

I had a similar problem .. and solved it with an extension (still work in progress)
https://github.com/jadwigo/bolt-photoalbum