I want to filter the data by content relationship in a group

lineagejourney · September 29, 2023, 5:42am

allEpisodess{
  edges{
    node{
      title,
      vimeo_url,
      thumbnail_image,
      priority,
      bts,
      _meta{
        id
      },
      categories{
 
          episodes_category{
            ... on Categories{
              title,
            }
        
          }
        
      
      }
    }
  }
}
}

I have above query



{
  "data": {
    "allEpisodess": {
      "edges": [
       
       
        {
          "node": {
            "title": [
              {
                "type": "heading1",
                "text": "Lineage S03 Behind The Scenes - Day 21-24",
                "spans": []
              }
            ],
            "vimeo_url": null,
            "thumbnail_image": {
              "dimensions": {
                "width": 2064,
                "height": 1988
              },
              "alt": null,
              "copyright": null,
              "url": "https://images.prismic.io/lineage/bd8a5315-3a4a-49ea-b456-cbdb85d93e06_S03-Day-21-24.png?auto=compress,format"
            },
            "priority": 32,
            "bts": "YES",
            "_meta": {
              "id": "YP-QGBIAACkASJjq"
            },
            "categories": [
              {
                "episodes_category": {
                  "title": [
                    {
                      "type": "heading1",
                      "text": "Season 3",
                      "spans": []
                    }
                  ]
                }
              }
            ]
          }
        },
        {
          "node": {
            "title": [
              {
                "type": "heading1",
                "text": "1888 General Conference Session",
                "spans": []
              }
            ],
            "vimeo_url": null,
            "thumbnail_image": {
              "dimensions": {
                "width": 5120,
                "height": 2542
              },
              "alt": null,
              "copyright": null,
              "url": "https://images.prismic.io/lineage/be20674d-f1f5-4879-acaf-2e06ecd83ac3_Episode-32.png?auto=compress,format"
            },
            "priority": 32,
            "bts": "NO",
            "_meta": {
              "id": "YP-SxxIAACoASKTc"
            },
            "categories": [
              {
                "episodes_category": {
                  "title": [
                    {
                      "type": "heading1",
                      "text": "Season 2",
                      "spans": []
                    }
                  ]
                }
              }
            ]
          }
        },
        {
          "node": {
            "title": [
              {
                "type": "heading1",
                "text": "Lineage S03 Behind The Scenes - Day 25-26",
                "spans": []
              }
            ],
            "vimeo_url": null,
            "thumbnail_image": {
              "dimensions": {
                "width": 2154,
                "height": 2160
              },
              "alt": null,
              "copyright": null,
              "url": "https://images.prismic.io/lineage/417dfa06-f3e6-467b-a232-2be62e655858_Lineage_S03_Behind_The_Scenes_%E2%80%93_Day_25-26.png?auto=compress,format"
            },
            "priority": 33,
            "bts": "YES",
            "_meta": {
              "id": "YP-TfxIAACgASKgO"
            },
            "categories": [
              {
                "episodes_category": {
                  "title": [
                    {
                      "type": "heading1",
                      "text": "Season 3",
                      "spans": []
                    }
                  ]
                }
              }
            ]
          }
        },
        {
          "node": {
            "title": [
              {
                "type": "heading1",
                "text": "Lineage S03 Behind The Scenes - Day 27-28",
                "spans": []
              }
            ],
            "vimeo_url": null,
            "thumbnail_image": {
              "dimensions": {
                "width": 2158,
                "height": 2160
              },
              "alt": null,
              "copyright": null,
              "url": "https://images.prismic.io/lineage/0788a99a-acce-46e0-854d-e230cd8830e0_Lineage_S03_Behind_The_Scenes_%E2%80%93_Day_27-28.png?auto=compress,format"
            },
            "priority": 34,
            "bts": "YES",
            "_meta": {
              "id": "YP-abBIAACwASMbp"
            },
            "categories": [
              {
                "episodes_category": {
                  "title": [
                    {
                      "type": "heading1",
                      "text": "Season 3",
                      "spans": []
                    }
                  ]
                }
              }
            ]
          }
        },
        {
          "node": {
            "title": [
              {
                "type": "heading1",
                "text": "Lineage S03 Behind The Scenes - Day 5-6",
                "spans": []
              }
            ],
            "vimeo_url": null,
            "thumbnail_image": {
              "dimensions": {
                "width": 2074,
                "height": 1988
              },
              "alt": null,
              "copyright": null,
              "url": "https://images.prismic.io/lineage/3d62703f-cdac-48d3-bc83-fa6b272353d7_S03-Day-5-6-.png?auto=compress,format"
            },
            "priority": 26,
            "bts": "YES",
            "_meta": {
              "id": "YP_BwRIAACoASXRE"
            },
            "categories": [
              {
                "episodes_category": {
                  "title": [
                    {
                      "type": "heading1",
                      "text": "Season 3",
                      "spans": []
                    }
                  ]
                }
              }
            ]
          }
        },
        {
          "node": {
            "title": [
              {
                "type": "heading1",
                "text": "Lineage S03 Behind The Scenes - Day 7-8",
                "spans": []
              }
            ],
            "vimeo_url": null,
            "thumbnail_image": {
              "dimensions": {
                "width": 2156,
                "height": 2160
              },
              "alt": null,
              "copyright": null,
              "url": "https://images.prismic.io/lineage/0c666165-782c-4e95-b0e2-775db0b307cd_Lineage_S03_Behind_The_Scenes_%E2%80%93_Day_7-8.png?auto=compress,format"
            },
            "priority": 27,
            "bts": "YES",
            "_meta": {
              "id": "YQAXpxIAAC8ASwCG"
            },
            "categories": [
              {
                "episodes_category": {
                  "title": [
                    {
                      "type": "heading1",
                      "text": "Season 3",
                      "spans": []
                    }
                  ]
                }
              }
            ]
          }
        }
      ]
    }
  }
}

I need a query that gives me allEpisodes that has episodes categories in "season-1"
"season-2"
"season-3". can anyone please help on this.

Phil · October 2, 2023, 12:48pm

Hi Clive,

You can filter with the where argument:

You need to filter by the ID of the category, like so:

query {
allEpisodess(where: {categories:{ episodes_category: "YOaXZBEAACsALbKS"}}) {
  edges{
    node{
      title,
      vimeo_url,
      thumbnail_image,
      priority,
      bts,
      _meta{
        id
      },
      categories{
 
          episodes_category{
            ... on Categories{
              _meta{
               uid 
              }
              title,
            }
        
          }
        
      
      }
    }
  }
}
}

Topic		Replies	Views
How do you query by a content relationship in a group, but in graphql? Developing with Prismic graphql	17	3920	April 25, 2023
Filtering by a content relationship in a group Developing with Prismic gatsby	3	520	April 6, 2022
GraphQL - Query by Content Relationship using a variable Developing with Prismic graphql	10	1492	December 9, 2021
Querying Content Links and Slices Developing with Prismic product-feature-idea , graphql	8	1942	December 9, 2021
Filter on content relationship nested field Developing with Prismic	2	686	August 4, 2023

I want to filter the data by content relationship in a group

Related topics