Thread

I am using the EE relationships field type to create a relation between two channels.  This is a one to many relationship specified by the child entry.  When displaying the parents on the child layout, I need to have the ability to filter results returned by the parents tag by a parent field value. 

I tried using the syntax below, but it does not work.

{parents field="related_entry" search:custom_field="custom_value"}
    {title}
{/parents}

Is something like this possible using EE relationships?  I am open to using other relationship fieldtypes if they support this functionality.

You may be able to filter using a conditional instead…

{parents field="related_entry"}
{if parents:custom_field == "custom value"}
    {title}
{/if}
{/parents}

I did try this approach, but it was going to be a pain to implement because I would have no way to tell if there were no results for my conditions. 

If there aren’t any better alternatives, I may have to do it this way, but I won’t be able to display a message for no results. 

I was just hoping that there was a better way.

This may work…

{parents field="related_entry"}
{if parents:custom_field == "custom value"}
    {title}

    {if:parents:no_results}
    Nothing found
    {/if}

{/if}
{/parents}

Or this…

{parents field="related_entry"}
{if parents:custom_field == "custom value"}
    {title}

    {if:else}
    Nothing found
    {/if}

{/if}
{/parents}

I will try your first suggestion.  I know for a fact that the second suggestion won’t work because it would print the no results text for every parent entry that didn’t match the field value.

Second suggestion did not work either because parents:no_results applies to the entire set of parents, not to the subset of parents that match the conditional.