Search in Grid field - Relationship

Question

I have a question concerning the function of research in Grid field, specifically on a relationship field. Here's my problem:

I have a grid field for a product catalogue, with many fields for each product specification. One of them is a relationship field, that catch the data from a "brand" channel. So I have

{exp:channel:entries channel="my_channel"}

{catalogue}

{catalogue:brand}

{catalogue:brand:brand_title}

{/catalogue:brand}

{/catalogue}

{/exp:channel:entries}

that shows me all the products on www.mysite.com/catalogue.

What I would like is to filter those products based on the brand, something like

segment_2 == brand_title

that will show, for example, all the Apple products on www.mysite.com/catalogue/apple and so on.

Is it possible? Thanks to everyone who will help me.

Answer 1

Have you considered the reverse? e.g. start at the brand channel and get the parents (e.g. products)? Might be more easy.

Grid is quite new and the relationship field also was recently changed (2.6) search and categories are not mature i guess (Relationship field tag parameters). Have you also tried Grid search:column_name=?

---

edit as noted in the comments below: "Currently it is not possible to get the parents of a relationship field that is inside of a Grid field".

An alternative is to use stash to store each item in a list, and store the brand with each item. On output or on setting the list, you can filter by brand. (e.g. match= against=)

See examples on: https://github.com/croxton/Stash/wiki/%7Bexp%3Astash%3Aset_list%7D

{exp:stash:set_list name="my_list" parse_tags="yes"}
  {exp:channel:entries channel="my_channel"}
    {catalogue}
      {stash:item_title}{catalogue:title}{/stash:item_title}
      {catalogue:brand}
        {stash:item_brand}{catalogue:brand:brand_title}{/stash:item_brand}
      {/catalogue:brand}
    {/catalogue}
  {/exp:channel:entries}
{/exp:stash:set_list}
...
{exp:stash:get_list .... }

Answer 2

I resolved using Matrix + Playa, although I'd have preferred to use native functions like Grid. Here's my code:

{exp:channel:entries channel="my_channel" dynamic="no"}

{catalogue search:brand="{segment_2}"}

{brand}

{brand_title}

{/brand}

{/catalogue}

{/exp:channel:entries}

Where {catalogue} is a Matrix field and {brand} is a Playa field that catch the data from the "brand channel". The dynamic="no" allows me to show only filtered entries in www.mysite.com/catalogue/(name of brand) based on {segment_2}, otherwise the list would remain blank.